We use conditional formatting to highlight several cells in a large worksheet. One of the colors used is the "light red fill..." which appears when "Highlight Cell Rules => Format cells that are less than..." is selected under Conditional Formatting.

Starting at row 3, I want to hide any rows that do not contain this color.

I see how the code in the last post of this thread can work to hide rows based on values but I cannot figure out how to change it to start at row 3 and how to get it to hide everything not containing that "light red fill" color.

Thanks in advance for any help,