Forum Discussion
Conditional formatting rules in multiple sheets
Hello, is there any way to highlight duplicates with conditional formating with columns on different sheets.
2 Replies
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
- Hello,
It is not possible to simultaneously apply conditional formatting to different columns in different sheet tab because when you group two or more sheets by using SHIFT key, the Conditional Formatting is greyed out... See the caption below.
However, you can "record" a macro in Sheet1, for instance, to highlight duplicate values using CF. Then, you go to Sheet2 and "run" the macro which will highlight all the duplicate values. You can do this running on many sheets.
Let me know if this helps
