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?