Overwrite pivot table conditional format based on row label

Question

Hi,

I want to know if it is possible to overwrite pivot table conditional format based on a specific row label text. 

At the moment, I have these rules....

The formatting for the last 3 has the same colour for "fill" & "font" because I don't need the numbers visible.  So it currently looks like this....

But I want to be able to amend the format based on the row label, e,g if row label starts with "ABS" then it formats a different colour.  So that it looks more like this.(Note, I had to do this manually by having to manually select each "ABS" line and format each one individually).

Is it possible to create a formula within the conditional formatting rules to achieve this? 

I've tried a few things but none have worked yet so any help would be appreciated!

Thanks,

Answer 1

Hi MRB,

As far as I know, using the one rule in the Conditional formatting, we can only format the cells with one color if the condition is true and if the same condition is false, the formatting of the cell will be blank and if both conditions are true, the formatting of cell depends on the highest ranking/priority of the rules in Conditional formatting.

Moreover, the formatting of cells in column B, C, etc., depends on whether the cell in the Column A starts with ABS, as per my knowledge, we need to applying conditional formatting for each row. Like this:

Best Regards,

Chitrahaas

Answer 2

Excel 365 Pro Plus with Power Pivot.

With colored Gantt Chart.

With real continuous dates/times.

No CF.

https://www.mediafire.com/file/pzvdp5kzjha3ehx/04\_19\_21.xlsm/file

https://www.mediafire.com/file/lai51i1e9ey55na/04\_19\_21.pdf/file

Answer 3

Hi MRB,

May I know if you have seen Chitrahaas's reply? May I know if you still need help? If so, you can post back and we will still try our best to help you.

Best Regards,

Sukie

Answer 4

Thank you for your reply Chitrahaas.  

So in summary,  you are saying what I require is not possible.  i.e. 2 colours to highlight specific cells based on whether they are over or below a certain figure and then another to pick out the rows starting with ABS.

Can anybody else advise?

Answer 5

Thanks Sukie, as you can see it doesn't actually resolve my query.  So any further help would be much appreciated - if it is indeed possible?