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.

Hi Kim,

Use following CFs for the both the cases respectively:-
For Green
=IF(AND(B1<A1,B1="Yes"),"True","False")

For Red,
=IF(AND(B1<A1,B1="No"),"True","False")

Note: You might need to set the colors.
--

Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"Kim" wrote:

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.

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.