Hi guys,
Hoping you can help out. I'm currently setting up a spreadsheet for our Spot Checks, Supervision, etc. Whilst I see myself as a quite well versed Excel user this has me stumped.
I have a cell which is providing the month at the moment, the cell is formatted to show "mmmm" with =TODAY().
I then have a list of my staff on the left with columns adjacent to these with the month they are due to have Supervision, this has been simply entered as Text due to the fact that the appointment can be made any point during that month.
I then want to Conditionally Format these cells.
Equal To Month would bring the cell up RED
Not equal to Month would bring the cell up GREEN.
However, I have a feeling as the month is in TEXT then it is not reading the Date in the =TODAY cell as matching.
I realise I could enter the months as a date then format it similarly to simply show the Month. However, I want to be using this spreadsheet into next year and obviously if I entered the dates of this year then it would not be valid into next year (Especially if I'm using a =NOW or =TODAY cell to show the month).
Any help would be greatly appreciated.
Many thanks in advance,
Solomon
Bookmarks