still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 821
- Office Version
- 365
- Platform
- Windows
Hi
I have in N79:N100 the last day of each month>>N79= June 30, 2019...N80=July31, 2019...N81=Aug 31, 2019...etc
I can't figure out how to write a conditional format to highlight the current month
Example:
This being July, I want to Highlight N80
after July 31, I want to that cell to go back to default and N81 gets highlighted
and continue like that till N100
mike
I have in N79:N100 the last day of each month>>N79= June 30, 2019...N80=July31, 2019...N81=Aug 31, 2019...etc
I can't figure out how to write a conditional format to highlight the current month
Example:
This being July, I want to Highlight N80
after July 31, I want to that cell to go back to default and N81 gets highlighted
and continue like that till N100
mike