Hi All,
Background: I have a cell That I'm checking these three conditions against.

B5= 100%, C5 = Blank

Three conditional formats:
=AND((B5-C5)>=1%,($B5-C5)<=9%) (Background=YelloW (91% to 99%))
=AND((B5-C5)>=10%) - (Background =Red (below 90%))
=AND((C5>=B5) - (Background=Green (100% or greater))

Problem: Before any data is entered the cells are all colored red because the value in them is 0 by default. Is there a way to get around this? I would like the user to enter a 0, have the cell check the conditions, and then turn it red. Can this be done?

Thanks for any help!