Selecting Rows for conditional formatting

Holly Donald

Hi, 

I have put some conditional formatting on my sheet. But there are certain rows I don't want it to apply to. Does anyone know how you can exempt particular rows/cells from formatting?

Thanks 

Mick Jordan

HI, how about have a checkbox called Exempt that is set to yes and a Conditional formatting rule is set to be the 1st rule executed which over-rules any subsequent rules?

Mick