I'm new to conditional formatting, and only have Excel 2003.

I don't have a problem getting my 3 desired rules entered and
functioning.

Red if a value <800
Yellow if a value falls between 800.01 and 1200
Green if a value 1200

My problem is that if there is no data yet (such as for months that
have not occurred, and thus there is no value, I use "N/A", but it
keeps showing Green.

I do not want any formatting applied if the value is "N/A".

I just inherited some Excel spreadsheets, and I have to make some
changes, but in the process, I found I don't know how to prevent
formatting from occurring for the "N/A" values.

Thanks for any help -- I have Googled this like crazy, but can't find
this topic referenced. Naturally, my deadline is Monday morning and
this is Saturday and I've been working on this since 5 AM and not
having much luck.

gDareos on a beautiful Saturday, chained to my computer . . .