Related:
- Conditional Formatting comparing dates
- Conditional formatting dates - Guide
- Apple iphone 13 release dates - Guide
- How to clear formatting in excel - Guide
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Different dates of "end to end encryption message" on blank chat? ✓ - WhatsApp Forum
1 response
Using the "Use a formula to determine which cells to format" rule of Cond. Formatting.
Color this range in Red.
=(($B1:$B10)-$D$1)<($A1:$A10)
Color this range in Green.
=(($B1:$B10)-$D$1)>($A1:$A10)
Applies to range:
=$B$1:$B$10
The $10 should be change to the number of row you are working with.
If the dates match then no color will be applied, so if needed use <= or >= in place of < or >
Where $D$1 contains the value to take off, in your example the value would be 100.
This will enable you to be flexible with the date differences.
Color this range in Red.
=(($B1:$B10)-$D$1)<($A1:$A10)
Color this range in Green.
=(($B1:$B10)-$D$1)>($A1:$A10)
Applies to range:
=$B$1:$B$10
The $10 should be change to the number of row you are working with.
If the dates match then no color will be applied, so if needed use <= or >= in place of < or >
Where $D$1 contains the value to take off, in your example the value would be 100.
This will enable you to be flexible with the date differences.