Using Excel 2003
I have a range of cells from A1 to A20 that has conditional formmating. If
someone enters a number from zero to 4.5, the background turns green. The
problem is, before someone even enters a number, the background is green. Why
is this? I don't want to confuse the data entry person. I have 2 other
conditions in those cells that turn the cells yellow and red when other
values are entered. How can I get rid of the green background?
Thank you, Karen