Formatting in Excel with a function

[samuelabyrd]

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?

[FDibbins]

there are no regular formulas or functions that will identify colors or text formatting in a cell.

how was the highlighting applied in the 1st place? if it was done through conditional formatting, or through so logic that can be programmed, then we can possibly base the new formatting on that?

edit: ok I see from your file that CF was not used, and the shading seems to be "random"

unless some1 (else) can suggest some VBA coding (and if you are prepared to use that), then I'm afraid you are kinda stuck

[:) Sixthsense :)]

Copy the below code
Open the workbook in which you want to add the code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
Close the Visual Basic Editor window to return to excel

To run the code:
Press Alt+F8 and select ColorMe and click Run

Please Login or Register  to view this content.

[samuelabyrd]

Genius! Excellent solution to the posted question. Thank you VERY much! This is awesome!