| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make row white unless the value of a certain cell is 0
You can modify the formula itself to return blanks....
OR (using conditional formatting) 1. Select the cell/Range 2. From menu FormatConditional Formatting 3. For Condition1Select 'Cell Value Is' and enter 0 4. Click Format ButtonFontColor select 'White' If this post helps click Yes --------------- Jacob Skaria "Josh" wrote: I have a massive list of formulas that arent in use untill the data is typed into certain boxes below them, I have a cell in each row with a value of '0' (untill edited) so what im asking is for the writing in that row to be white then when the value is changed to 0 it turns black, is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to shade a cell but when I print it, I want it white. | Excel Discussion (Misc queries) | |||
| I want to shade a cell but when I print it, I want it white. | Excel Discussion (Misc queries) | |||
| EXCEL workbook is off-white, goes white in edit mode | Excel Discussion (Misc queries) | |||
| Conditional formatting a #N/A return in a cell? I want it white. | Excel Discussion (Misc queries) | |||
| White Space in a Cell | New Users to Excel | |||
Threaded Mode
