Related:
- Conditional Formatting comparing dates
- Excel conditional formatting if another cell contains specific text - Excel Forum
- How to clear formatting in excel - Guide
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- Phone formatting software for pc - Download - File management
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.
