| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare two columns within a worksheet, then highlight duplicates | Excel Worksheet Functions | |||
| How do I highlight cells on a worksheet that contain formulas | Excel Worksheet Functions | |||
| Possible? If total in a worksheet 0, highlight worksheet tab? | Excel Worksheet Functions | |||
| worksheet is locked on highlight how do I unlock it | Excel Worksheet Functions | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
Linear Mode
