Previous Topic Next Topic

Conditional formatting

Closed
Sriram - Jan 13, 2016 at 07:45 AM
Hello,

I need a help from you .

Am trying to give three color condition in a pivot table and slicers report.

We have sheet with Pivot table and slicers with many data in each cell.

For eg : (Sheet1) A column with name B column with Percentage.
(sheet2) A column with name B column with Percentage (FIXED BASE %)

With this two sheet need give a three condition.
1st :- When the (Sheet1) Percentage is less than(sheet2) Percentage it should be in RED COLOR.
2St :- When the (Sheet1) Percentage is greater than (sheet2) Percentage it should be in GREEN COLOR.
3rd:- When the (Sheet1) Percentage is Above 20% of (sheet2)Percentage it should be in AMER COLOR.

Can any solve my issue

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

5 responses
Conditional formatting with multiple rules and blank text cells
PaiviM -
PaiviM -

6 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response