View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Janis Janis is offline
external usenet poster
 
Posts: 360
Default fr default color index, need color #

I need to strip out all rows that are in two colors of gray in a spreadsheet.
In the help file it has a picture of the color index with all the color
numbers however in
my color palette it does not line up with the color index. It has a smaller
number of colors
so I don't get how to get the number?

If you know the numbers corresponding to the default palette it is the first
gray color above the white colored square to the right of the default
palette and the other gray color is the darker gray directly above it. Can
you get me the two numbers ple-aze.

If you could tell me the method to fine the color number that would be
helpful but I really just need those two numbers to start a macro that will
delete all rows with those colors.

thanks,