How do you apply conditional formats to fields in pivot tables in Excel for Mac?

How do you apply conditional formatting to different fields in Excel for Mac (running 16.34) -- so that one value will show different conditional formatting when filtered by different fields? I cant seem to replicate this feature from excel running on a pc. 
Answer
Answer

Hi Ann&&,

I compared the "Manage Rules" feature on Windows and Mac, I found that the difference is Windows has the "Apply Rule To", however, Mac doesn't have it.

I searched a lot and found that this feature is not available yet on Excel for Mac.

Please take a moment to send us your feature request(s) by submitting your requirement in the Excel for Mac UserVoice. If you would like this feature to be included in Excel for Mac you may submit your views. Your voice is also important to us.

Appreciate your understanding.

Best regards,
Jazlyn
-----------------------

* Beware of scammers posting fake support numbers here.

* Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

 
 

Question Info


Last updated October 7, 2020 Views 159 Applies to: