Thread: CF for Text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kim Kim is offline
external usenet poster
 
Posts: 284
Default CF for Text

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.