Conditional Formatting: Color of a cell by date AND value

Closed
Lauren - Mar 18, 2014 at 05:03 PM
 Lauren - Mar 21, 2014 at 11:51 AM
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

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Mar 18, 2014 at 10:16 PM
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
That worked like a charm! Thank you so much for your help, it is GREATLY appreciated!
-Lauren
0