Ok, so I'm a bit of a newbie so please don't rip into me to much! lol

I've created a spreadsheet tracking sales metrics and have inserted conditional formatting so that if it's above so and so % it marks green, and below that percentage it marks green.

It's a week by week basis that we fill in the stats, but the columns that I haven't even filled in are green, when I want them to be blank.

I've attached a picture, if I'm not making much sense...


excelcondformatting.JPG