Conditional formatting
 

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

Conditional formatting
 

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)

--
sb
"Nick Wakeham" wrote in message
...
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

Conditional formatting
 

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
-----Original Message-----
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


.

Conditional formatting
 

Use a formula like this in column K.
=IF(ISBLANK(G1),"",C1+E1)

HTH,
Merjet