Related:
- Conditional Formatting: Color of a cell by date AND value
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Excel date format dd.mm.yyyy - Guide
- Conditional formatting if another cell contains any text ✓ - Excel Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Conditional format based on another cell containing text - Excel Forum
2 replies
Mazzaropi
Posts
1983
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 27, 2023
146
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