Conditional Formatting: Color of a cell by date AND value

[Closed]
Report
-
 Lauren -
Hello,

I am attempting to have a cell change colors based on the amount of time passed since a bill was sent, only if the bill is unpaid. In column B the billing date appears, and in column E the outstanding balance appears. I want column D to turn RED if the date in Column B is 90 days or more before present ONLY IF there is any balance in column E. How would I write this formula please? Very new to Excel!

Thank you!

2 replies

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
Lauren, Good evening.

B1 --> billing date --> 12/19/2013
E1 --> balance --> 100

Select D1
Use the Conditional Format
Using formula
=AND(E1>0,(TODAY()-B1)>=90)
Choose the colour you prefer.
OK

Try to change a date billing to see the D1 Cell colour appearing and disappearing depending on quantity of day passed over date billing.

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

That worked like a charm! Thank you so much for your help, it is GREATLY appreciated!
-Lauren