Forum Discussion
Conditional formatting for x number of days before
Rick151 so as JMB17 indicated your reference is wrong. Your 'Applies to' field is $E:$E which means your top left most cell is E1 but your formulas all use E3 which is why everything is off by 2 rows. You can change the formulas to use E1 and it will work.
That said, you could also just use the built in conditional formatting:
and then you don't need any cell references.
And alternative solution instead of having 3 conditional formatting rules you can use ICON sets instead:
a different look which may or may not be good for what you want.
Rick151 so as JMB17 indicated your reference is wrong. Your 'Applies to' field is $E:$E which means your top left most cell is E1 but your formulas all use E3 which is why everything is off by 2 rows. You can change the formulas to use E1 and it will work.
That said, you could also just use the built in conditional formatting:
and then you don't need any cell references.
And alternative solution instead of having 3 conditional formatting rules you can use ICON sets instead:
a different look which may or may not be good for what you want.