Openoffice change colour of cell if.....

Associate
Joined
26 Jan 2007
Posts
2,462
Hi, I have currently got a problem (eg me being rubbish at cell based programs :o).

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 :p)

=IF(B3:B4>B2;B6=

But my brain petered out and my reserves of logic have run out....



Anyhelp appreciated.
 
Cheers. I have NO idea on what conditional formatting is :(


Need to brush up on my skills, the world is leaving me behind :O


P.s the formula for calculating the final price is =sum(b3+b4-b2) , I just need to figure out how to get it to change colour if its less than zero (turn red) or turn colour if its greater than zero (green).
 
Back
Top Bottom