Conditional Formatting: Color of a cell by date AND value

Lauren - Mar 18, 2014 at 05:03 PM
 Lauren - Mar 21, 2014 at 11:51 AM

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 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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
Choose the colour you prefer.

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
That worked like a charm! Thank you so much for your help, it is GREATLY appreciated!