If i have a list of specific dates E5, E6, E7 etc and I have =Today() in J1
Is it possible make specific fields B5:R5, B6:R6, B7:R7 etc, change colour depending on the timeframe between E5, E6, E7 and J1
Looking for 3 seperate colours;
2 weeks prior to specific date
1 week prior to specific date
Any day after specific date
Is this done in conditional formatting? Any assistance would be greatly appreciated.
Is it possible make specific fields B5:R5, B6:R6, B7:R7 etc, change colour depending on the timeframe between E5, E6, E7 and J1
Looking for 3 seperate colours;
2 weeks prior to specific date
1 week prior to specific date
Any day after specific date
Is this done in conditional formatting? Any assistance would be greatly appreciated.