Conditional Formatting Data/Time with XLOOKUP
Hello,
I have two columns, one of which contains a date and time in a “M/D/YY h:mm AM/PM” format, and another that contains the same, but derived via XLOOKUP. I want to enable a conditional formatting function that would look at the two columns and fill in red when the date or time do not match. For example:
1/1/23 12:00 PM1/1/23 12:00 PM1/1/23 12:00 PM2/1/23 12:00 PM1/1/23 12:00 PM1/1/23 12:30 PM1/1/23 12:00 PM1/1/23 12:00 AM
I have tried “=$A1<>$B1”, but it highlights every cell red, I suppose because the second column is derived via XLOOKUP which makes it always non-identical to the first. Is there a function that can compare the values of the cells as seen?
Hello, I have two columns, one of which contains a date and time in a “M/D/YY h:mm AM/PM” format, and another that contains the same, but derived via XLOOKUP. I want to enable a conditional formatting function that would look at the two columns and fill in red when the date or time do not match. For example: 1/1/23 12:00 PM1/1/23 12:00 PM1/1/23 12:00 PM2/1/23 12:00 PM1/1/23 12:00 PM1/1/23 12:30 PM1/1/23 12:00 PM1/1/23 12:00 AM I have tried “=$A1<>$B1”, but it highlights every cell red, I suppose because the second column is derived via XLOOKUP which makes it always non-identical to the first. Is there a function that can compare the values of the cells as seen? Read More