Create Pivot Table to compare 2 Dimensions and according mark Status

[#1]

Hello All,

I need to create Pivot that table that would compare in two dimensions and update Status for each Run ( Pass, Fail, No Run )

Also Pass filled with Green Color and Failed with Yellow

	Run 1	Run 2	Run 3	Run 4	Run 5
Test 1	Pass	Pass	Pass	Pass	Pass
Test 2	Pass	Pass	Fail	Pass	Pass
Test 3	Pass	Pass	Pass	Pass	Pass
Test 4	Pass	Pass	Pass	Fail	Fail
Test 5	Pass	Pass	Fail	Pass	Pass
Test 6	Pass	Pass	Fail	Pass	Pass
Test 7	Pass	Pass	Pass	Pass	Pass
Test 8	Pass	Pass	Fail	Fail	Pass
Test 9	Pass	Pass	Pass	Pass	Pass
Test 10	Pass	Pass	Pass	Pass	Fail

Any help would be great.

BR.