Creating conditional formatting of a column cells on the basis of some other column cell values in a Pivot Table...

Hi All,

I am just stuck on one issue.

I am having a Pivot Table which is having  5 rows with 2 value columns. (e.g. value1 and value2)

And my need is to color RED all those cells of value1 column which is having corresponding value2 column value less then 50.

e.g.:

I know that I need to apply a conditional formatting for this. But no idea how to do.

If some one can help with sample code.

Note: number of value columns will always be 2 but number of rows may differ. 

Pranay...

Hi,

Seems every one is busy..

I am still waiting for some helpful replies...

Hi Pramod,

hoping help from your side..

Hi Pranay,

               Conditional formatting is a pretty straight forward thing to achieve. Here, in your case you need to refer some other column for creating a formula. I am trying to prepare a working solution for this.

Thanks Pramod for your response.

Waiting for solution.