Problems With Conditional Formatting

I created a conditional format based on the sales for a particular brand to highlight that brand in a table in all fields. However, when I scroll up and down in the table (fairly long table), the formatting get screwed up and starts coloring cells that are obviously not supposed to be. It is obvious that it is just freaking out, because if I refresh or go to another page & back, it fixes itself. But this looks unprofessional and is not something I can share with end users. (Also, being able to conditionally format row headers based on text criteria would actually be much simpler and solve the "workaround" I had to do that is probably causing this.)