Conditional formating.

[mangesh]

Hi,
I have written a sentence in cell A1 as "standard reporting procedure". Now my query is if any word in cell A1 contains "standard or "std" the cell should be highlighted with red background.

Appreciating your help.

[NBVC]

Try this formula in the Conditional Formatting window:

=OR(ISNUMBER(SEARCH("standard",A1)), ISNUMBER(SEARCH("std",A1)))

[oldchippy]

Hi,

Try this in Conditional formatting > Formula is

=OR(SEARCH("standard",A1,1),SEARCH("std",A1,1)) format to your requirements

[mangesh]

Thannks for your help.
I tried it but its not working.

[NBVC]

Which did you try?

[mangesh]

I got it now, I had tried the other one. But when i used your formula its working now.