Possibly an =IF statement??

[Sawdeeka01]

Hi, I am hoping someone could assist me please.

I am helping someone with a spreadsheet and they are wanting to flag dates at various stages.

Essentially they are looking for two queries;

- When 10 business days have passed column P (Closing date), column W (Selection Report finalised) will highlight orange (please note at this stage column W will be blank), and;
- When 19 business days have passed column P (Closing date), column W (Selection Report finalised) will highlight red (please note at this stage column W will be blank).

Any help you could provide would be awesome, thank you so much and I hope you have a great day!

 

[Michael M]

Use Conditional Formatting for both....Here is the first question.
I'm guessing you can do the rest

 

[Sawdeeka01]

Hi Michael,

Thank you for looking at this for me, unfortunately it isn't working. It isn't formatting the cells at all, if I take out the reference to today it works but does not pick up the second query re 19 days?

 

[Michael M]

Did you add the 19 day rule to the CF table...as I mentioned

I'm guessing you can do the rest

You simply add a new rule to the CF table with

=Today()=$P$2+19

....and format as required

 

[Sawdeeka01]

Did you add the 19 day rule to the CF table...as I mentioned

I'm guessing you can do the rest

Sure did but nothing is happening at all

 

[Sawdeeka01]

I have followed your instruction to the T and unfortunately it still isn't working....

 

[Michael M]

Works fine for me...2 rules 1 for P2+10, 1 for P2 + 19

 

[Michael M]

Are you sure you want EXACTLY 10 and 19 Days ??
and NOT Greater than or equal to 10 and 19

 

[Sawdeeka01]

Hmmm I have the same, 2 rules, 1 for P3+10 and 1 for P3+19 days but the formatting isn't coming through, still white cells regards if they have a date in them or not

 

[Michael M]

Okay but the date has the be EXACTLY 10 days and 19 days different.
If it's 11 or 20, or anything but 10 and 19, it won't change the cell !!