View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob
 
Posts: n/a
Default How do I sort or count cells by fill color?

I have a spreadsheet that contains pasted data from an online database. The
imported cells are color coded with RED, YELLOW, and GREEN fill. I would
like an automated way to calculate the number of RED, YELLOW, and GREEN cells
in the data. Any thoughts?