View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
amaries amaries is offline
external usenet poster
 
Posts: 21
Default 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).