How I do this?

H

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
 
O

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
 
S

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!
 
Top