I am having troubles setting up the conditional formating for a
worksheet. I have been trying to set up a format that highlights the
cell ONLY when the value is greater than one, but it isn't working.
The formating not only highlights the cell when the value is greater
than 1, it also highlights the cell when the value is " ", is there any
way to stop this from happening?