Related:
- Conditional Formatting comparing dates
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Different dates of "end to end encryption message" on blank chat? ✓ - Network Forum
- Using nested if to blank out adjacent cells - Excel Forum
- After formatting computer what's next ✓ - Laptop 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.
