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
|