Hi,

Here's one way.

In the name manager (on the formulas tab), define a name called Letters which refers to this:
={"A","F","T"}

Then, in the conditional formatting, create a new rule which uses a formula to determine which cells to format as this:
=OR(ISNUMBER(FIND(Letters,A1)))

Where A1 is the subject cell.


This will be case sensitive. If you don't want it to be case sensitive then use the SEARCH() function instead of FIND().