Bug ?? - Excel 2007 Format Wizard formats values incorrectly (icon

[George]

Hi
In Excel 2007, I am highlighting two columns of data (%) and creating a new
Conditional Formatting Rule. I create a traffic light format with green >
80%, amber between 75 and 80 percent and the rest as red. HOWEVER I then get
inconsistent formatting - ie it seems to be ignoring the 80% cutoff. Of the
data, I get green for 89,90,98 - anything >= 88%, amber for 86,87, then red
for anything else.
If I go into Manage Rules, Edit Rule - the thresholds are correct.
Can anyone help me here? This is driving me mad.
George

 

[Roger Govier]

Hi George

Try using 0.8 rather than 80% as your criterion

--
Regards
Roger Govier

Hi
In Excel 2007, I am highlighting two columns of data (%) and creating a
new
Conditional Formatting Rule. I create a traffic light format with green >
80%, amber between 75 and 80 percent and the rest as red. HOWEVER I then
get
inconsistent formatting - ie it seems to be ignoring the 80% cutoff. Of
the
data, I get green for 89,90,98 - anything >= 88%, amber for 86,87, then
red
for anything else.
If I go into Manage Rules, Edit Rule - the thresholds are correct.
Can anyone help me here? This is driving me mad.
George

__________ Information from ESET Smart Security, version of virus
signature database 4830 (20100203) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4830 (20100203) __________

The message was checked by ESET Smart Security.

http://www.eset.com