2007 Excel conditional formating, reference cell containing specif
 

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.

2007 Excel conditional formating, reference cell containingspecif
 

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

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

then set your format.

Hope this helps.

Pete

On May 15, 11:45*pm, Lostinthought
wrote:
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.