Conditional Formatting Issues

[g.costapinto]

Hello all,

I'm having issues with Excel's Conditional Formatting and I'm hoping you'll be able to help me solve this. I've put together an excel table that compares 'planned costs' to 'incurred costs' and provides the resulting variances. As the table is dynamic, I've had to use the following formula for calculating variances:

=IFERROR(B2-C2,"")

I've also applied conditional formatting to this particular column, that highlights any cells "Greater Than" 0 (zero) with Light Red Fill with Dark Red Text and any cells "Less Than" 0 (zero) with Green Fill with Dark Green Text.

The issue I'm having is that any cells that are left blank due to the formula shown above, are having the conditional formatting applied for "Greater Than" applied to them. I have tried implementing formatting specifically for cells left blank, but this doesn't seem to work.

Any ideas on how to work around this?

Cheers,
G

[AliGW]

Use a formula for the CF instead:

=AND(cell>0,cell<>"")

=AND(cell<0,cell<>"")

Replace cell with the correct cell reference for the start of the CF range.

[g.costapinto]

Thank you so much Ali, that worked perfectly!

Cheers,
G