Related:
- Conditional Formatting: Color of a cell by date AND value
- Excel copy conditional formatting color to another cell ✓ - Forum - Excel
- Excel count conditional formatting color cells - Forum - Excel
- Conditional formatting greater than another cell - How-To - Excel
- Conditional formatting based on another cell date - How-To - Excel
- Conditional formating - apply on more cells ✓ - Forum - Excel
2 replies
Mazzaropi
- Posts
- 1943
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- September 22, 2021
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
