Change your conditional format formula from this (generalize because you did
not post your actual formula)...

=YourCondition

to this...

=AND(YourCondition,ActiveCell<"")

where ActiveCell is the same cell reference that you have in YourCondition.

--
Rick (MVP - Excel)


"pearce" wrote in message
...
I have a column that I want to use conditional formating on. Some cells are
blank. I want them to remain blank and un shaded. The other cells contain
values between 0 and 6. I want values between 0-2 to turn red, 3-4 to turn
yellow and 5-6 to turn green. How do I do this?

So far I've managed to apply shading but the blank cells also turn red
instead of staying clear.