Formatting in Excel with a function

Hello,

Apologies if this is not properly placed within the formus.

I'd like to know how to create a rule or formula within the formatting section that will recognize the highlighting for the account numbers on the Accounts worksheet, and apply the same highlighting to columns A:K and AL:AP on Sheet 1.

Is that even possible with a formula?