Conditional formatting

[Tomo]

Hi Using Excel 2003

I want to make a cell change colour if it meets with one on the following

if it contains the word "fred" of "harry"

The limits of 2003 are three conditional per page and the other two are used so need to have this in one rule any help thanks

 

[AlphaFrog]

Try something like this where cell A1, in this example, is the cell with the data.

Formula is =OR(ISNUMBER(SEARCH(A1,"Fred")), ISNUMBER(SEARCH(A1,"Harry")))

 

[T. Valko]

Hi Using Excel 2003

I want to make a cell change colour if it meets with one on the following

if it contains the word "fred" of "harry"

The limits of 2003 are three conditional per page and the other two are used so need to have this in one rule any help thanks

Will "fred" or "harry" be the only word in the cell or will there be other words including "fred" or "harry"?

 

[Tomo]

Other words will be in the cell the exact list are as follows and it is to cover a range of cells from a1 to s50

"OK" will colour it green
"OVERDUE" will colour it red
"REMINDER" OR "BOOK NOW" needs to be in yellow

it is the third one i am have difficulty with due to the limitations of excel 2003

 

[grizz]

=A1="ok" ----- format green
=A1="overdue" ---- format red
=or(isnumber(search("reminder",A1)),isnumber(search("book now",A1))) -- format yellow

then click A1 and copy --- highlight A1:S50 -- paste special / click formats and ok

 

[Tomo]

Working thanks a lot.....

 

[T. Valko]

=A1="ok" ----- format green
=A1="overdue" ---- format red
=or(isnumber(search("reminder",A1)),isnumber(search("book now",A1))) -- format yellow

Another way to write the longer formula:
=COUNTIF(A1,"*reminder*")+COUNTIF(A1,"*book now*")