conditional formatting (2000)

Topic

New Reply

Hi, I need your help again. I’m trying to use Conditional Formatting if a cell contains the word Request. The problem is that the cell contains Request then the date which it went out. or it may say Request and a persons name. How do I get excel to conditional formate if the cell cantains anywhere in it the word Request. (not case Sensitive)
Thanks for all your help

Reply | Quote

Replies

Select the region (Assume A1:A100)
Format – cond formatting
formula is:

=NOT(ISERROR(SEARCH("request",A1)))

Change format as desire

The cell in the formula is the “activecell”

Steve

Reply | Quote

Select the region (Assume A1:A100)
Format – cond formatting
formula is:

=NOT(ISERROR(SEARCH("request",A1)))

Change format as desire

The cell in the formula is the “activecell”

Steve

Reply | Quote