CF for Text
Use this CF formula fro your red condition...
=AND(A1<B1,B1="Yes")
and this one for your green condition...
=AND(A1<B1,B1="No")
--
Rick (MVP - Excel)
"Kim" wrote in message
...
Can someone please help with with a formula for conditional formating for
text.
A B
1 No Yes
2 Yes Yes
3 Yes No
4 No No
I need to set CF for column B to:
If B is not the same as A and B = Yes (turn green)
If B is not the same as A and B = No (turn red)
Thanks.
|