Hi, I have currently got a problem (eg me being rubbish at cell based programs
).
Anyway, I have
3 columns
Two are positive values (profit) which are calculated elsewhere and the answers are put into cells B3 and B4.
The third column is the cost and is in cell B2.
What i'm trying to do is get B3 and B4 to take away B2 and if it is greater than 0 (eg if the books are in the plus) then to turn the cell B6 green, otherwise turn it red, whilst showing the value.
In fairness I did try (not being totally lazy
)
=IF(B3:B4>B2;B6=
But my brain petered out and my reserves of logic have run out....
Anyhelp appreciated.

Anyway, I have
3 columns
Two are positive values (profit) which are calculated elsewhere and the answers are put into cells B3 and B4.
The third column is the cost and is in cell B2.
What i'm trying to do is get B3 and B4 to take away B2 and if it is greater than 0 (eg if the books are in the plus) then to turn the cell B6 green, otherwise turn it red, whilst showing the value.
In fairness I did try (not being totally lazy

=IF(B3:B4>B2;B6=
But my brain petered out and my reserves of logic have run out....
Anyhelp appreciated.