Hi I have a sheet that needs to colour cells based on whether they are occupied with a Yes or a Date, I cannont fathom out the If(or( statement for conditional formatting, any ideas would be greatly appreciated.

Cheers

JD