macro to apply conditional formatting
The incoming csv file first has a top row with a report name (Open Orders).
The records come in 'Promise Date' order (column G). The final product the
mgrs want to see is Open orders grouped by customer# (column A) and sum if
the customers order totals (column N). Then colorized based on the 'status'
of the order (column K).
|