Conditional Formatting: Color of a cell by date AND value
Closed
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!
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!
Related:
- Conditional Formatting: Color of a cell by date AND value
- Excel conditional formatting based on date - Guide
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Formatting windows 7 - Guide
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
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
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
