Conditional Formatting

[VictoriaM575]

Hello Excel Fellas!

I have a "Target Completion Date" cell (which is a formula). I want this cell to pop when the date exceeded 90 days from TODAY. How can I do this? It seems simple, and I've tried different conditional rules but none of them have worked. Any suggestions???

 

[Smitty]

Welcome to the Board!

You can use Format only cells that contain-->Cell Value-->Greater than-->=TODAY()+90

HTH,

 

[VoG]

If you mean the date is > 90 days in the past try the CF formula

=TODAY()-A1>90

Change A1 to suit.

 

[VictoriaM575]

Welcome to the Board!

You can use Format only cells that contain-->Cell Value-->Greater than-->=TODAY()+90

HTH,

Thanks for the suggestion. I tried this one but it didn't work. As you can see with the formatting below, it highlighted the dates that will occur in 90 days rather than dates that are after 90 days.

Cell Value --> greater than --> =TODAY()+90

 

[VictoriaM575]

If you mean the date is > 90 days in the past try the CF formula

=TODAY()-A1>90

Change A1 to suit.

I tried this one too, but it didn't work.

 

[VoG]

Please explain exactly what you want to do. Is it 90 days before ore after today?

 

[VictoriaM575]

Please explain exactly what you want to do. Is it 90 days before ore after today?

90 days after today...

 

[VoG]

=a1-today() < 90

 

[VictoriaM575]

=a1-today() < 90

I tried this but it didn't work either. For example, it highlighted a date value 8/12/11, however, that date is not after 90 days from today. I tried reversing the sign (from "<" to ">") but all dates were highlighted when these values aren't after 90 days from today...

 

[VoG]

Working here

Excel Workbook
	A
1	24/09/2011
2	24/10/2011
3	23/11/2011
4	23/12/2011
5	22/01/2012
6	21/02/2012
7	22/03/2012
8	21/04/2012
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =A1-TODAY()>90	Abc