How do I highlight cells in a worksheet having a particular value?

  • Thread starter Thread starter Alok
  • Start date Start date
A

Alok

I have a worksheet in which I have "true" written in cells located in
diferent rows and columns. I want to highlight all the cells containing this
value. What should I do?
Changing the color of the the text in these cells will be better.. pls advice
 
Select the area with the cells, do format>conditional formatting, cell value
is equal to and type in TRUE
click format button and select pattern then click OK twice to get out of
conditional formatting


--


Regards,


Peo Sjoblom
 
Back
Top