How to conditional format with multiple criteria (Excel Pivot table)

Question

I have an Excel pivot table with no set boundaries (boundaries depend on what slicer option the user select).

In Column A: I have the store information such as daily sales volume and other value information. Since there are countless stores, this information repeats for each store. Sales_Volume column is placed in the VALUES section area in PivotTable Fields (Along with other columns that are also placed in the VALUES section, but I am only concerned with Sales_Volume column).

In Column B - xxx: I have the daily dates in the COLUMNS section area in PivotTable Fields so starting from Column B contains the Sales_Volume information for that day (Along with other values,but I am only concerned with Sales_Volume column). Every 9th row starting from row 13 contains the Sales_Volume value for that day.

What I want is for the conditional formatting to search for the the word "Sales_Volume" in Column A and for that Row color the cell red for any values in that row that are less than 200.

Does that makes sense? So ONLY every 9th row starting from row 13 would contain the conditional formatting (if the values are less than 200 in those specific rows only).

Any help would GREATLY appreciated!!

Answer 1

Perhaps a helper column could work for you...create another column with the formula of =AND(A1="Sales_Volume",B1<200). This would either return TRUE or FALSE, and you could conditionally format that column.

Answer 2

I found the solution if anyone is interested:

I used the same formula listed here: "=AND(B6<200, $A6="Sales_Volume")" however, my fix came from selecting the entire workbook from the first row that I wanted the conditional formatting to be set on so my selected range was: B6 - XFD1048576 and voila!