Forum Discussion
Formatting based on searching for identical cell in another sheet
Hi, Does anyone know if it is possible to do this? I have two spreadsheets containing data from two consecutive months. In the earlier spreadsheet, let's say I have a list of customers colour cod...
Are the customers on the first sheet color-coded manually or using conditional formatting?
To copy the comment, you can use an IFERROR/VLOOKUP combination, or XLOOKUP if you have Microsoft 365 or Office 2021.
Thank you, XLOOKUP works for the comments! Colour coded manually on the first sheet.