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

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

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

Select the area with the cells, do formatconditional 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



"Alok" wrote in message
...
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