His questions: I want to select the entire values in the status cell that contains red formatting and put it in a summary sheet
On my own, i did a lot of data checks > i had to clean the data with so much data inconsistency and then i used PQ to finish off the work so if he selects Red cell(<= 3 Month of Expiration green means as i have indicated below)
So he wanted to see if the company selects Red color to see all the warehouses location that has expired.
Do you think i approach it well? what would you have done differently? Reason i am sharing is for knowlegde sharing