Conditional formatting help

[hufmania]

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

[DGagnon]

what are you doing on the worksheet that is causing your applys to range to change?

[hufmania]

I am typing, adding rows, deleting rows, cut & paste, etc

[scantron]

I'd love to hear this too.... applying multiple ranges of the same damn conditions seems to eventually cause problems.

[DGagnon]

Adding and deleting rows will change your applies to range, i dont think there is away around this.