|The conditional formatting is an important aspect. |
In excel, I have a linked pivot table from access that I am trying to conditional format. The formulas are correct but it doesn't extend down into the final few rows, even though my "Applies to" formula looks correct.
Basically I just need to highlight the rows based on an exact text in one of the columns. If J5-J100 (or more) = "COOKT", I want to highlight the entire row from the area of A5:L100(or more)
The formula I am using for a rule is =EXACT($J7,"COOKT") and for the "applies to" area, I use =$A$5:$L$200
The issue, is that some of the rows at the bottom aren't formatted like this, for some reason, even though the last row is A48:L48. And when I clear the rules, and enter the formula again, it isn't consistent. It actually has more rows that are not formatted. Then if I clear it again and do the same, thing something else happens.
I'm wondering if this is just a known issue with conditional formatting and access pivot tables in excel? As this has happened before when i use pivot tables.
Let me know if you have a solution!