CF in Pivot Tables- on a specific item

[Shay A]

Hi,
In the file attached, I would like to highlight only the figures for March. Is it possible?

Thanks and Happy New Year!
Shay

 

[Hui]

select B6:L9 or L8
Goto CF
New Rule
Use a Formula
=B$5="March"
add the Format you want and apply

 

[Shay A]

Hi,
Can't I do it throgh the pivot table itself? After I choose a certain rule for my pivot table, I get this little arriwbwith three options. However, none of them referers to items, only to fields.

Ty

 

[rahulshewale1]

hii,

please see attached sheet.


Thanks
Rahul