AUTOMATIC HIGHLIGHT

  • Thread starter Thread starter Kavita.
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

highlighting cell 1
Highlighting Active working area 3
Need to highlight cells in special order 0
How do I Highlight a row, where something is found? 2
Shift + Home highlights entire worksheet to top, not single row 2
Conditional Formatting help 4
Excel Typed text appears in wrong cell 0
Creating a formula to highlight a row of cells 3

Back
Top