View Single Post
 
Old 10-03-2011, 08:49 AM
Lucky Lucky is offline Windows XP Office 2007
Novice
 
Join Date: Oct 2011
Posts: 2
Lucky is on a distinguished road
Question Conditional formatting with AND, OR

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?
Reply With Quote