I have a cell in which I want it formatted to a yellow background if the
value is = 100. I have formatted it and it works fine. However, when the
cell is blank, it is the yellow background color of the greater that 100
formatting. I just want the cell to be blank when it has no value. How can I
do this? I have tried adding another "blank" formatting for when the cell is
less than 100, but it doesn't work. Any ideas, or can this not be done?