You need to be super careful that when you are applying color to filtered
cells, that you select ONLY cells with the "blue" row indicators. IF you
also select the header row or anything below the "blue" rows, the color will
be mis-applied.
--
Gary''s Student - gsnu200908


"Pat B" wrote:

When I filter my worksheet based on column A, for example, and adding a value
or color to those filtered values, things seem okay. However, when I remove
the filter all records (even the ones that were filtered out).

is there a setting in excel options that will allow me to shut that off so
when I copy/paste or fill the filtered values, it only affects those values -
not the ones that are hidden (or filitered out).

Thank you in advance for any help you can provide.