AUTOMATIC HIGHLIGHT

K

Kavita.

Is there any way to highlight whole row?? i have entered text as obsulate,
current .. etc so i want to highlite whole row when i enter the text in
obsulate, so is is possible?? is there any way to highlight whole row??

If yes then please somebody help me out.
Thanks
 
S

Sheeloo

Assuming you have the text to check is in Col A
Then select the rows you want to highlight
Choose Conditional Formatting
Choose FORMULA is
enter the formula as
=$A1="obsulate"
choose the formatting you want
and press Ok.
 
Top