On a worksheet named Date Issues, I have a list of ID's in column B, and a date in column AF in the format DD-MMM-YYYY. This date could be any day of the month.
On a worksheet named Financial Issues, I have the same list of ID's in column A. In column D on this worksheet, I have dates in the same DD-MMM-YYY format, but this will always be the 1st of the month.
I need conditional formatting in this column D to identify where the month and year do not match the month and year from the Date Issues worksheet for the same ID.
Is this possible? Could I please trouble someone for the conditional formatting formula for this?
Both worksheets have column headers, and this is for Excel 365.
Thanks!
On a worksheet named Financial Issues, I have the same list of ID's in column A. In column D on this worksheet, I have dates in the same DD-MMM-YYY format, but this will always be the 1st of the month.
I need conditional formatting in this column D to identify where the month and year do not match the month and year from the Date Issues worksheet for the same ID.
Is this possible? Could I please trouble someone for the conditional formatting formula for this?
Both worksheets have column headers, and this is for Excel 365.
Thanks!
