I am having a problem with conditional formating. I have a bunch of cells
that I am appling conditional formating to but the formatting is not working
as it should.
Condition 1: Cell Value less than or equal to 0.3*$C4 fill:=Red
Condition 2: Cell Value greater than 0.3*$C4 and less than or equal to
0.8*$C4 fill:=Yellow
Condition 3: Cell Value greater than 0.8*$C4
fill:=Green

All the cells that I applied these conditions to are RED. And I can't figure
out what it is that I did, or am doing, wrong.
Any help will be greatly appreciated. Thanks