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!