2007 Excel conditional formating, reference cell containing specif

[Lostinthought]

I need to add a fourth condition to an array. This fourth condition needs to
reference a cell only when that cell contains a specific text string. The
preceding numbers will change, however the text will be based off of three
sets of specific text. Basicaly N1 changes color if A1 CONTAINS xyz. N1
already changes color three ways based off of a date formula. Please advice.

 

[Pete_UK]

Set up a 4th rule for N1 with Formula Is:

=ISNUMBER(SEARCH("xyz",A1))

then set your format.

Hope this helps.

Pete