Conditional formatting rules in multiple sheets

[Ocasio27]

Hello, is there any way to highlight duplicates with conditional formating with columns on different sheets.

[#2]

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

[#3]

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