1 person found this helpful
Hi I had a similar situation...
i dont know if its right.. but it worked. I created a second column with the same values.. And then conditional formatted the first column referencing the second column ...
Both the columns will have same values... but when conditionally formatting column 1.. we will say if column 2 is PASS then column 1 Green if column 2 is FAIL then Red in column 1.
Hope this helps.
I tried doing this. It did not work for me.