Here's the deal...I'm importing a file from an email. I'm trying to CF the
cells to light up red when the value is greater than 5. When I use that
condition, ALL cells turn red. If I delete the numbers that are in the cells
and type them in myself, the CF works properly. Why doesn't the formatting
work with the numbers I've previously pasted in?