Select cells of interest
<format<conditional formating
change "cell value is" to "formula is"
formula is
=and(M17=0,N17$P$2)

Set the patern format to orange

note I often need to go back into the conditinal format section to remove
unwanted Quote marks and make sure my references stay absolute or relative
as wanted. Why they change from what I want sometimes, I have no clue.


"PW11111" wrote:


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