Forum Discussion

lulubee22's avatar
lulubee22
Copper Contributor
Apr 07, 2022

How to Conditional Format Filtered Data

Hi,

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.

No RepliesBe the first to reply

Resources