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.