It sounds as if the values you've copied in from the email are text, and not
numbers. Any text is counted as being greater than any number.
You can check whether it's text or number by =ISTEXT(A2) and =ISNUMBER(A2).
If they are text, you might be able to convert, either by Data/ Text to
Columns, or by Edit/Paste Special to add zero or multiply by 1.
--
David Biddulph

"mailrail" wrote in message
...
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?