ChrisMac1
New Member
- Joined
- Jul 15, 2024
- Messages
- 38
- Office Version
- 365
- Platform
- Windows
Hi there,
I have a workbook called Complete_Asset_Fields.xlsx which is made up of two sheets, CompleteAssetFields and Sheet1.
I need to highlight all the values in column BC on the sheet CompleteAssetFields, that also appear in column A on Sheet1.
Can you help me with the formula to use in Conditional formatting please?
Many thanks,
Chris
I have a workbook called Complete_Asset_Fields.xlsx which is made up of two sheets, CompleteAssetFields and Sheet1.
I need to highlight all the values in column BC on the sheet CompleteAssetFields, that also appear in column A on Sheet1.
Can you help me with the formula to use in Conditional formatting please?
Many thanks,
Chris