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.
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.