Hi,

I have a cell in a spreadsheet that I want to colour orange when certain
things happen. I have tried and tried to do the formula (which i don't think
is that hard) but i can't get the cell to change colour.

I will describe the formula a need to plain english below. Any help you
could give me would be great.

M17 = Date Completed
N17 = Date Required
P2 = Today()

My formula needs to say:

If M17 = 0 (uncompleted) and N17 is greater than today (P2) then go orange.

Hope this makes sense.!

Cheers,

Phil