Why is Conditional Formatting Grayed Out in Excel?

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on April 13, 2022

This article will demonstrate why Conditional Formatting may be grayed out in Excel and what to do.

 

cond format greyed out

 

If you are trying to apply some formatting to your worksheet but find that the Conditional Formatting option on the Ribbon is grayed out, it’s usually for one of two reasons. Either your worksheets are in Group Mode, or your workbook has been shared (and is therefore in Shared Mode).

Conditional Formatting Grayed Out

Grouped Spreadsheets

You cannot use Conditional Formatting when you are in Group Mode.

To ungroup worksheets, click on the tab of a sheet that’s not in the group. This will immediately takes you out of group mode.
If all the sheets in the workbook are grouped together, right-click on any of the grouped sheet tabs and click Ungroup Sheets.

 

Grouping ungroup sheets

 

The Conditional Formatting option on the Ribbon becomes available.

 

cond format available

 

Shared Workbook

Similarly, if a workbook is shared, you won’t be able to use Conditional Formatting.

 

cond format shared

 

To stop sharing your workbook, in the Ribbon, select Review > Unshare Workbook.

 

cond format unshare

 

You can then use Conditional Formatting.

 

AI Formula Generator

Try for Free

See all How-To Articles