Conditional format of text in a pivot table

andreasjaeger

New Member
Joined
Mar 7, 2011
Messages
5
Hi,

I am on the verge of giving up, but wanted to post my case before doing so, in hopes that some might have attempted the same as me.

1) I am using Excel 2010

2) I want to rank a list of factories (good, neutral, bad) based on each factory name

3) My base is a pivot table.

My target
when factory a,b,c is displayed, show backgound = green
when factory d,e,f is displayed, show background = orange
when factory g,h,i is displayed, show background = red

My trouble (I think)
1) It's a pivot table, I cannot go to each cell and type in a formula (which I would do in normal circumstances, and it would work okay)

2) I cannot find out how to setup the conditional formatting in excel 2010, based on my pivot. I am tring to use the conditional formatting, then select the option showing "based on specific text" which however works regardless of I put in

a,b,c
"a","b","c"
'a','b','c'

as the text qualifiers.

If any one have ANY IDEA / SUGGESTION I would welcome it with open arms.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Claymationator

Well-known Member
Joined
Sep 26, 2006
Messages
705
Welcome to the board!

When you say company a,b,c is selected, is that one company as in Company ABC, or 3 separate companies as in Company A, Company B, and Company C?

When you make the selections for the different companies, what area are they in within the pivot table (report filter, rows, columns)?
 

andreasjaeger

New Member
Joined
Mar 7, 2011
Messages
5
Hi Clay, many thanks for posting a reply.

It would be in following scenario, e.g. production schedule

factory a + factory b + factory c = did not yet submit audit = red alert
factory d + factory e + factory f = did submit = green / go-ahead

I have in total 4 different statuses to be considered, where for each status there will be a selection of multiple factories.

There is a screenshot I'd like to share, but not sure if I can do it by posting it on this forum, otherwise I can email you ?
 

Forum statistics

Threads
1,141,734
Messages
5,708,157
Members
421,549
Latest member
Dtcfire

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top