Conditional Formatting Dates

[brobert95]

Hello, I am having trouble getting conditional formatting to work and I'm wondering if it has something to do with the reference cell having a formula instead of a value. In Cell A1 I have the formula =today() and in C1 I have a date. In D1 I have formula =days(C1,$a$1) to give me the how many days it has been from the date in C1 to today. I would like to have conditional formatting that changes the cell color of C1 to yellow if the days are over 60 and orange if they are over 90, but can't get it to work. Thanks in advance for any help.

 

[Micron]

Sample data is always better because it helps to eliminate some questions. If your C1 date value is earlier than (less than) A1 then the result is negative, so a negative result will never be greater than 60 (or any other +ve number). In that case, reverse the cell references or use ABS to get the absolute value.

 

[Peter_SSs]

In D1 I have formula =days(C1,$a$1)

Could that be the wrong way around?

Is this what you are trying to do?

23 09 10.xlsm
	A	B	C	D
1	10/09/2023		5/05/2023	128
2			29/06/2023	73
3			27/08/2023	14
4			24/04/2022	504
CF Days

Cell Formulas
Range	Formula
A1	A1	=TODAY()
D1:D4	D1	=DAYS($A$1,C1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D1:D4	Expression	=D1>90	text	NO
D1:D4	Expression	=D1>60	text	NO