Conditional Formatting and Filtering

Hi

Is there a way to have to the conditional formatting rules change as i filter? I am using conditons based on the row above or below and when i filter some of these rows disappears resulting in the formatting not looking the way I want it.

Thanks

Hi,

Please post a sample template of your workbook here with details on the kind of formatting.