VBA to make a list of formatted cells.

[cwhite86]

I have an spreadsheet i am making to help process my inventory at work.

The next thing I would like to do is make a list on a sheet of all the values that are formatted on a range of other sheets.

The other sheets all have values that are conditionally formatted based on whether they are found on the master list and vice versa.

There is only one formatting. It's either highlighted or not.

Can I write a VBA macro to generate a list of the highlighted cells on a given worksheet, or range of sheets?

[cwhite86]

This is the formula I use to format the master list.

Please Login or Register  to view this content.

This is the formula I use to format the product pages.

Please Login or Register  to view this content.