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.
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.
Seems every one is busy..
I am still waiting for some helpful replies...
hoping help from your side..
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.