Pivot table with formatted cells - Conditional formating

[SarahK]

Hello.

I have a pivot table that has all numbers (For the value it is #'s). I formatted the cells so now they appear as follows:

1 = Access
2 = No Access

So now instead of #'s it shows the words. Now what I am trying to do, is put conditional formatting around these cells. For example, I would like all of the cells that are saying Access to have a border around them and the No Access to be shaded in. I am not having any luck doing this. Is it not possible to do a conditional format if you have a custom format in the cells?

Thank you,
Sarah

 

[Somendra Misra]

Hi Sarah,

Can you upload a small sample file.

Regards,

 

[SarahK]

It will not allow me to upload this. Here is a snip it of it. Hope this will help.

 

[SarahK]

When you click in the cells that say Access or None, it actually shows up the number 1 or 2.

 

[Somendra Misra]

Select Cells, Put below formula in CF and apply format.

=[Relative Cell Address eg A1]=1.... Apply format
repeat same with new rule =2 different format.

Regards,

 

[SarahK]

Thank you so much. It finally worked!

 

[Somendra Misra]

Glad you solve it. Welcome back anytime.

Regards,