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?
|