conditional Formatting in certain text on a pivot Table

[howard]

I have tried to apply CF to use fill color Blue to Highlight Col A:C where "Total Sales WIP" appears in Col A


It would be appreciated if someone could assist me, by providing the steps to do this

 

[Joe4]

Select columns A:C for all rows you want to apply the Conditional Formatting to, then enter the following CF formula (in this example, I am assuming row 2 is your first row):

=$A2="Total Sales WIP"

and then choose your desired formatting.

 

[Marcelo Branco]

Take a look at
https://www.contextures.com/excelpivottableconditionalformat.html

M.

 

[howard]

thanks for the help.


managed to get the CF to work