Forum Discussion
Ocasio27
Jan 28, 2020Iron Contributor
Conditional formatting rules in multiple sheets
Hello, is there any way to highlight duplicates with conditional formating with columns on different sheets.
Wyn Hopkins
Jan 28, 2020MVP
Hi Ocasio27
If you want to flag in Sheet1 the items that exist in a column on Sheet 2 then you can do this by writing a formula in your conditional formatting
Wyn
MVP
Australia UTC+ 8
If this answer was the best response please click the button
I also happily accept likes