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

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
 
P

Peo Sjoblom

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
 

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 matching cells in two different worksheets 3
How to colour highlight empty cell 2
Conditional format a column based on value in a different column 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Compare two Cells and highlight third cell 3
Highlight the cell based on selected value 2
conditional formatting in an IF function? 1
How do I highlight cells on a worksheet that contain formulas 3

Top