Can't find things in new format pane!

BoundedInANutshell

New Member
Joined
Nov 25, 2021
Messages
7
Office Version
  1. 365
Platform
  1. Windows
Where on earth is the conditional formatting option in the "new style" format pane (which I hate). I'm just can't find it. I'm looking at a card visual at the moment.

ANY help greatly appreciated.

Thanks
Jason
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
what does your ribbon look like? Mine still has a clear conditional formatting icon
 
Upvote 0
The new formatting pane, and how to turn it off.

In general, the options are better located nearer to all of the other options. So, it depends on which part of the card you want to format: the value is Visual → Callout Value → Color, the lable is Visual → Category label → Color, the background is General → Effects → Background.

It took a little while for me to get used to, but honestly for me the fixing of the double scrollbar (among other things) was more than enough for me to keep with it.
 
Upvote 0

Forum statistics

Threads
1,223,674
Messages
6,173,746
Members
452,533
Latest member
Alex19k

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top