I’m new to excel, so please bear with me.
I work in a food distribution warehouse, and my company uses an excel sheet that displays the picks per order for a given department. I want to use this spreadsheet to display where each department is in the days work. We use a voice pick program that will show me what status the order is (complete, in use, available,etc.), and I can export this data to a new excel file. How do I go about using this exported data to conditional format my spreadsheet? If possible I would like to use grayscale colors of the cell to determine the status of the order (white= available, light gray=in use, dark gray=complete)
On the spreadsheet, the order numbers are in column A, starting from top to bottom of the sheet. The department names go across row 1, and each cell at the cross section (the area I'd like to format) shows the picks for that order, for that department.
The exported file can be arranged however, but for ease I’ll make it order number in column A, department in column B, and status in column C.
Hopefully I explained well enough, and used the correct terms! Thanks to anyone who can help, as I’ve googled for weeks, but can’t seem to find a similar problem.
In the attached file, I used different sheets, but in practice this would have to be done using linked files.
Bookmarks