![]() |
#1
|
|||
|
|||
![]()
Hi All,
I need to add conditional formatting on a cell. A requirement is: if the cell should be highlighted yellow if value contains letters A, F, or T. I’m trying to use “Format only cells that contain” -> Cell value -> Equal to -> AND (“A”, “F”, “T”), but looks the excel takes it literally ="AND(""A"", ""B"", ""C"")" ![]() What would you recommend? |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting | namedujour | Excel | 3 | 08-25-2011 01:46 PM |
![]() |
Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |
![]() |
djreyrey | Excel | 3 | 06-03-2011 01:54 AM |
Conditional formatting of Today +21 days? | SHERMAN | Excel | 3 | 12-20-2010 08:08 AM |
Challenge!! Need help though. (Conditional formatting) | knuckles70 | Excel | 2 | 02-05-2010 12:24 PM |