Forum Discussion
Conditional formatting rules in multiple sheets
Hello, is there any way to highlight duplicates with conditional formating with columns on different sheets.
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
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
