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
- Excel conditional formatting color scale based on another cell ✓ - Forum - Excel
- Excel conditional formatting based on another cell text ✓ - Forum - Excel
- Conditional formatting greater than another cell - Guide
2 replies
Mazzaropi
Mar 18, 2014 at 10:16 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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