View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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