JoeNichols
New Member
- Joined
- Jun 1, 2019
- Messages
- 6
I am trying to add conditional formatting using end of month.
What I am hoping to have is this:
Enter a date in "A1"
Next "A2" has formula "=EOMONTH(A1,36)"
I would like to have three conditional formats showing
"Green" if today's date is in the preceding calendar month or earlier than "A2"
"Yellow" if today's date is within the calendar month of "A2"
"Red" if today's date is after the calendar month of "A2"
I would also like to have this shown on a different sheet in the same workbook if possible.
Thanks.
What I am hoping to have is this:
Enter a date in "A1"
Next "A2" has formula "=EOMONTH(A1,36)"
I would like to have three conditional formats showing
"Green" if today's date is in the preceding calendar month or earlier than "A2"
"Yellow" if today's date is within the calendar month of "A2"
"Red" if today's date is after the calendar month of "A2"
I would also like to have this shown on a different sheet in the same workbook if possible.
Thanks.