I have a column, where I enter in a month something needs to be completed(there is no specific date, just a month).
So eg. Col A would be like:
I need it to highlight red the current month based on todays date (so right now, all the 'November' cells would be highlighted red)
All cells containing a month earlier than the current month in grey (so currently October,September,August etc)
The month following the current month, in yellow (So December)
The only part I have working, is for the current month:
This currently highlights anything with 'November' in it.
I need the formula for previous months, and the next following month.
Does that explain better? I'm sorry I can't upload any file to demonstrate...