Sorry about the tongue twister of a title.
I am trying to conditionally format a cell with the following parameters:
If empty no formatting
If cell value = 0 then turn orange
If cell value < 0 then turn red
If cell value > 0 then turn green
I know this is technically 4 conditions (of which excel 2003 accepts only 3) but I feel that there must be a formula of some sort that could achieve this.
Thanks in advance.