Creating a List based on conditional formatting

I am trying to help my wife streamline the workflow of her design business.

Individual Rooms have their own sheet - eg. Club Room, Break Room, Lounge, Cyber Cafe, etc.

Those sheets contain an itemized list of furnishings, cost, budget, etc.

I created a simple rule through conditional formatting to highlight each piece that is over budget (G column is Budget, H column is cost) So the formula was =$H2>$G2, if true the Cost cell is highlighted red.

What I am trying to accomplish is a rule that takes over budget items from all the individual sheets (individual rooms) and compiles a list of over budget items in a separate sheet - Items Over Budget.

Any help is appreciated!



Creating a List based on conditional formatting


As per my understand this attachment should help you....