Excel 2003 more than just conditional formatting

[sooze29]

Does anyone know a way in which you can highlight specific cells that contain a word. For example I can use conditional formatting to highlight cells containing the word Tuesday, but if the cell contains 'today is Tuesday' it won't work. Any suggestions?

 

[1726]

try conditional formatting with a formula of the form:

=FIND("tuesday",LOWER(cell_ref))

 

[sooze29]

That works perfectly, thank you so much.

 

[sooze29]

Hi there

It worked and then I closed Excel and tried to redo it and it did not work. In the cell ref should it be okay to select the entire worksheet?

 

[combo]

Set relative references in conditional formatting, for instance for A1:
=FIND("tuesday",LOWER(A1))
Now extend formatting or copy formats to the range you need to check.

combo