Conditional Formatting: Color of a cell by date AND valueClosed

Question

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!

Mazzaropi · Answer

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

Lauren · Answer

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

Conditional Formatting: Color of a cell by date AND value

2 replies

Subscribe To Our Newsletter!