How to Conditional Format Filtered Data

Copper Contributor


I have a table with filtered data. I'm trying to use the color scale conditional formatting only on the data which is filtered and displayed, but what in fact happens is that the color scale is coloring also the hidden and not filtered cells.  How can I conditional format only the filtered rows that are visible?  I want to be able to use my filters and the conditional format should color depending on what the visible rows are from the filters.

0 Replies