Conditional Formatting across Multiple Tabs in one Work Sheet

Question

Hi, I would like to know if I can set a Conditional Format for a Particular Column across multiple TABS withing the one Worksheet .

In my example, Column B across all TABS has "Invoice numbers", I want to run a loop across the whole Worksheet that will pick up whether I have duplicated any particular Invoice number , and if so, to highlight in say #38 Excel colour . Is this possible ?

Answer 1

You may upload file in private message. I will try both conditional formatting and Macro.

Private Messages - Microsoft Community

Answer 2

Hi Snow, I'm back again..

Are you able to give me a step by step instruction on how you got that final code set up?

I ask because it's going to be a problem when I start a new year and new tabs.

It's good you did that spreadsheet yesterday, but I need to know the selection criteria etc and code set up so I can do it myself moving forward.

Answer 3

I think the only way may be via VBA ?

Are you able to assist if I provide the spreadsheet

Answer 4

Is there someway I can attach the file to this email ?

I can't seem to activate One Drive ??

Answer 5

Could you share a test file? You may upload it to OneDrive or any other cloud drive for testing and then post the link here.

*Please make sure you have removed any sensitive or private information in the sample file before uploading.

Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

You may set conditional formatting like this one.

=(COUNTIF(B:B,B1)+COUNTIF(Sheet2!B:B,B1)+COUNTIF(Sheet3!B:B,B1))>1