How I do this?

[HR157]

I need a formula that looks for some conditions and color them. Fo
example:
When I write in A1 "checks " the formula search all the worksheet an
color( or highlighted) in red all words “checks”.

:confused

 

[mrice]

Have a look at the help on conditional formatting

 

[Otto Moehrbach]

A formula can only return a value and it can return that value only to the
cell in which it resides. You will need VBA to do what you want. Post back
if you need help with that. HTH Otto

 

[Ron de Bruin]

You can use CF

See
http://www.contextures.com/xlCondFormat02.html

 

[shelfish]

Here's a suggestion. In all the cells that you would like to be
potentialy highlighted, select them and go to "Format> Conditional
Formating"

In the dialog box go with 'cell value is' 'equal to' '=$A$1'

Then select the format button and choose the highlight color or
whatever formating you want and click ok.

Now anything that matches what is in cell A1 will have that formatting.


I hope this helps.

Cheers!