Thread: Filter on Color
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ssGuru ssGuru is offline
external usenet poster
 
Posts: 63
Default Filter on Color

I have code that highlights cells in certain records based on my
rules. I have code that removes these highlights.

Works just great.

Now I would like to be able to create a filter that will JUST show the
rows where one or more cells are highlighted. I am currently using
only 3 colors, Light Yellow, Lavender and Pink for the highlighted
cells.

I haven't found any clever way to display just the rows WITH
highlighted cells.

Any ideas,
Dennis