Forum Discussion
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 forma...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
I have edited my post to include a drive link showing what I have tried. Thank you!
Thanks.
Columns E/F contain date+time values.
The formulas in columns I and J use the TEXT function, so they return text values. Simply remove TEXT from the formulas:
=IF(XLOOKUP(A2,Sheet1!A:A,Sheet1!E:E,"")="","",XLOOKUP(A2,Sheet1!A:A,Sheet1!E:E,""))
See the attached version.
I could've sworn I tried it without the TEXT function, but I guess I didn't. It seems to work now, thank you for the help!
