Conditional Formatting - Greater then / Less then / 0 or blank

[angusn]

I'm trying to do something that I think is simple but just can't get the last conditional format.

I have 2 columns B (weight) & C (% up or down) with 32 Rows. It is a weight loss chart that colour codes the ups and downs.
Cells in Column C have the formula "=IF(B32="","",((B32-B31)/B31))" to leave the cell blank if the cell in column B has no typed in value.


The formatting I have is as follows:

1. If Cell C32 is Greater than 0 shade it Red - Works
(Cell Value Is less than 0)

2. If Cell C32 is Less than 0 shade it Green - Works
(Cell Value Is Greater than 0)

3. If Cell B32 is Empty than C32 should have no colour. - Problem is that Cells Stay Red.
Formula Is =IF(ISBLANK(B32),"",IF(B32=0,B32,""))

Any quick ideas?

....but now that I read it a couple times I would need something that also states if cell in column C is equal to zero do not shade as well.

 

[carrolljm]

Is it column C that is turning red? Do you want to show these formulas or are the formulating and then another cell is showing the answer?

 

[angusn]

Hey there, I have what works for me to make the cells with formulas in column C unformatted.

Cell value Is less than 0, format green
Formula is =B6="", no format
Cell value Is greater than 0, format red