Hello Guru's! I've got three rules setup in conditional formatting and they work fine except for one ongoing issue. The area that the formula applies to should be locked at =$a:$f. Whenever the sheet is modified the "applies to" area changes. This causes the rules to malfunction. How can I lock down the "apply to" area so it will never change?

Thanks,
Eric

See attachment for visual.


3-6-2012 5-23-10 PM.jpg