But didn't the OP say that he wanted the *whole row* to be white if the
value in the one cell was zero?
--
David Biddulph
"Andrea Jones" wrote in message
...
An easy way to do this is to use Excel's normal number formatting.
Highlight
the cells containing the formulae and press CTRL+1. Set the format to
number
with however many decimal places you would want if a value was displayed
and
then click on Custom. You should see a format like
0.00
Now type a ; after this to create a negative number format and type the
same
format code but with a minus sign in front, e.g.
0.00;-0.00
Finally add a semicolon to the end of this to create a zero format but
don't
type anything after the final semicolon
0.00;-0.00;
You will now find any zero values disappear but positive and negative
values
will format as shown.
Andrea Jones
www.allaboutclait.com
"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?