Conditional formatting

  • Thread starter Thread starter Nick Wakeham
  • Start date Start date
N

Nick Wakeham

I know this is probably something SO simple that I just cannot see it for
looking at it:

I am using conditional formatting in a spreadsheet of figures
Column G has a total from Column C and E (same rows)
But I want Column G to be blank when nothing is in the same row in colum E.
I have the formula: if(e1<>0,g1+c1+e1,"") and that works beautifully.
However, I then have a Column K which is using the value in Column G to work
out a Net figure.
If I use the same formula then I get an error as there is a formula in
Column G already.
So I am stuck with #VALUE! in Column K.
How do I get a blank column in K if there is no actual figures showing in
Column G?
Hope I make myself clear - it's been a long day!
Thanks
Nikwak
 
Nick,

If your formula in column G is working, than use the same criteria in
column K: If(E1<>0,.......
It should work out...
(not sure why you're getting #Value)
 
Nick,

Instead of using
if(e1<>0,g1+c1+e1,"")
you can use:
if(e1<>"",g1+c1+e1,"")

and do the same thing in column k.

Regards,
Felipe
 
Back
Top