Conditional Formatting

[Worzel Gummidge]

In cell H1, I have a date inputted. In cell I1, I want the date to be
automatically calculated from H1+7 dates. So, if for example H1 = 12th Nov
2005, I want 19th Nov 2005 to automatically appear in column I1.

Now further to that, in cell J1, I have a drop down menu listing values
"yes" and "no." If today's date (the date the spreadsheet is accessed) is
passed the date in cell I1 AND J1 = "no" then I want the background colour
in cell J1 to be changed to pink. If the value in J1 = "yes" then I want
cell background colour to remain as it is

Thanks all

 

[JE McGimpsey]

One way:

CF1: Formula is =AND(I1=TODAY(),J1="no")
Format1: <patterns>/pink

 

[Worzel Gummidge]

Formaly didn't seem to work unfortunately - probably because I explained it
poorly.

The conditional format will be placed in cell I1.

If J1 = either blank or "no" and today's date (the date that the spreadsheet
is accessed) is greater than the value in I1, then I would like cell I1 to
be formatted as pink.

 

[JE McGimpsey]

One way:

CF1: Formula is =AND(I1<TODAY(), OR(J1="no",J1=""))
Format1: <patterns>/pink

 

[Worzel Gummidge]

Great JE McGIMPSEY

Problem solved - thanx

One way:

CF1: Formula is =AND(I1<TODAY(), OR(J1="no",J1=""))
Format1: <patterns>/pink