Hello,
I need to color a column based on a date in a cell.
The tricky part is that the condition format condition is only dependent on the month.
Let me give an example:
Criteria:
4/18/2016
the data table looks like this:
2/1/2016 3/1/2016 4/1/2016
You can see the 4/18/2016 is not an exact match for any of the dates in the table.
I need the column 4/1/2016 to be colored.
So basically, if the month and year are a match then color it and dont pay attention to the day
I dont see how I can attach a file or else I would.
I do have a file posted here though: https://onedrive.live.com/redir?res...889&authkey=!AEE4aagNu4Ee0ok&ithint=file,xlsx
You might have to save a copy though. See the ellipses on the far right (three dots) to download it.
I have conditional formatting already on the sheet & it works only if there is an exact date match.
thank you
I need to color a column based on a date in a cell.
The tricky part is that the condition format condition is only dependent on the month.
Let me give an example:
Criteria:
4/18/2016
the data table looks like this:
2/1/2016 3/1/2016 4/1/2016
You can see the 4/18/2016 is not an exact match for any of the dates in the table.
I need the column 4/1/2016 to be colored.
So basically, if the month and year are a match then color it and dont pay attention to the day
I dont see how I can attach a file or else I would.
I do have a file posted here though: https://onedrive.live.com/redir?res...889&authkey=!AEE4aagNu4Ee0ok&ithint=file,xlsx
You might have to save a copy though. See the ellipses on the far right (three dots) to download it.
I have conditional formatting already on the sheet & it works only if there is an exact date match.
thank you
