Forum Discussion
Highlight Based on Cell Reference Location
I have a work book that I have multiple pricing sheets in that we have been able to go through entire jobs to find the best purchase. The sheets are based on Master sheets in another work book so the...
which sheet is pulls the cells being referenced from
How about consolidate all sheets to one sheet before furture analysis?
How about consolidate all sheets to one sheet before furture analysis?
The Master work book is pulling data from 9 other workbooks I am trying to create a sheet inside the Master work book to view the max and min prices for each product. This sheet will have around 500 Rows to accomplish this. My hope is to have a way to highlight or color code the max and min result based on the location of the referenced cell it pulls it data. The issue with trying to consolidate the data is the product descriptions vary for the same product reference so I am creating targeted cells for the max and min