| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide value of cell if value same as other cell
Hi Art,
You can use ConditialFormat for the range B1:H10 In cell B1 add contdialformat using formula =COUNTIF($A1:A1,B1)0 Set the color for font to the same color as the background . Next use the "Copy/Past format" brush to copy to the rest range mentioned above. HTH, Wouter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide cell unless value entered into any cell on a row | Excel Discussion (Misc queries) | |||
| How can I change the size of a cell and hide what is in the cell? | Excel Worksheet Functions | |||
| Hide cell based on value of another cell | Excel Worksheet Functions | |||
| auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
| Hide cell values based on a condition in another cell | Excel Worksheet Functions | |||
Threaded Mode
