Conditional Formatting - Not working.

Okay. I am either being REALLY dim or my Excel is broken.

So I have set up Icon Sets for a table with Conditional Formatting yet it doesn't seem to work.

I have it set up so

Greater than or Equal to <= 90% is a Green tick,
Less than 90 and Great than or Equal to 90% is Orange/Yellow Exclamation point
Less than <80 is a red Cross

Yet as you can see it doesn't lay it out that way. HELP please

\1

Dear kacey8,

Please attach sample file.

Regards,
Nandkumar S.

Attached

Sample.xlsx

I was not having the 2007 version..
So I tried with what is available...




Don't forget to click *

Hi, I can see how you did that. Thanks

I think the problem was my conditional formatting was set by % not by number.

Dear kacey8,

find attached.

Regards,
Nandkumar S.