Issue about CF rules manager dialog

%3CLINGO-SUB%20id%3D%22lingo-sub-1689910%22%20slang%3D%22en-US%22%3EIssue%20about%20CF%20rules%20manager%20dialog%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1689910%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20recently%20got%20a%20problem%20with%20Conditional%20Formatting%20Rules%20Manager.%3C%2FP%3E%3CP%3EIt%20was%20normal%20several%20weeks%20before.%20But%20I%20recently%20found%20the%20width%20of%3C%2FP%3E%3CP%3Ethe%20dialog%20is%20not%20long%20enough%20to%20display%20the%20%22Applies%20to%22%20and%20the%3C%2FP%3E%3CP%3Efollowing%20column.%20It%20looks%20like%20the%20%22Format%22%20column%20is%20too%20long%20to%3C%2FP%3E%3CP%3Edisplay%20following%20columns%20in%20the%20dialog.%20Unfortunately%2C%20the%20dialog%20does%3C%2FP%3E%3CP%3Enot%20support%20scroll%20horizontally.%20As%20the%20result%2C%20I%20can't%20view%20and%20edit%20those%3C%2FP%3E%3CP%3Ecolumns...%20See%20attached%20image.%20Wondering%20is%20there%20any%20way%20that%20I%20can%3C%2FP%3E%3CP%3Ecustomise%20the%20size%20of%20this%20dialog%20or%20enable%20horizontal%20scroll%20for%20the%20dialog.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestion%20would%20be%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20very%20much%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESc%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1689910%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1689987%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20about%20CF%20rules%20manager%20dialog%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1689987%22%20slang%3D%22en-US%22%3EThanks%20very%20much%20anyway.%20No%20worries.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1689983%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20about%20CF%20rules%20manager%20dialog%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1689983%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F800792%22%20target%3D%22_blank%22%3E%40Hare0319%3C%2FA%3E%26nbsp%3BAh%2C%20I%20see.%20Then%20I'm%20not%20able%20to%20help%20you.%20Sorry.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1689979%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20about%20CF%20rules%20manager%20dialog%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1689979%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BI've%20updated%20the%20image%2C%20which%20contains%20a%20CF%20rule.%20Please%20have%20a%20look%2C%20from%20this%20image%20you%20can%20see%20that%20the%20%22Applies%20to%22%20is%20not%20displayed%20completely.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20very%20much.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esc%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1689973%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20about%20CF%20rules%20manager%20dialog%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1689973%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20very%20much%20for%20your%20reply.%3C%2FP%3E%3CP%3EYes%2C%20the%20image%20I%20uploaded%20is%20from%20a%20blank%20workbook.%20That's%20why%20there's%20no%20active%3C%2FP%3E%3CP%3Econditional%20format.%20But%20as%20we%20can%20see%20from%20the%20image%2C%20there's%20only%20three%20columns%3C%2FP%3E%3CP%3Edisplayed%2C%20%22Rule%2C%20Format%2C%20Applies%20to%22.%20And%20the%20Applies%20to%20column%20is%20really%20close%20to%3C%2FP%3E%3CP%3Ethe%20right%20border%20of%20the%20dialog.%20And%20there's%20no%20enough%20HORIZONTAL%20space%20for%26nbsp%3B%3C%2FP%3E%3CP%3E%E2%80%9CApplies%20to%22%20and%20%22Stop%20if%20True%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esc%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1689938%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20about%20CF%20rules%20manager%20dialog%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1689938%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F800792%22%20target%3D%22_blank%22%3E%40Hare0319%3C%2FA%3E%26nbsp%3BThe%20picture%20you%20uploaded%20suggests%20that%20your%20%22Current%20selection%22%20does%20not%20contain%20any%20CF%20rules.%20Change%20to%20%22This%20worksheet%22%20at%20the%20top%20in%20stead%2C%20or%20select%20the%20range%20for%20which%20you%20want%20to%20edit%20the%20rules%20first.%20Then%20press%20the%20CF%20button%20to%20see%20the%20active%20rules%20for%20that%20range.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi,

 

I recently got a problem with Conditional Formatting Rules Manager.

It was normal several weeks before. But I recently found the width of

the dialog is not long enough to display the "Applies to" and the

following column. It looks like the "Format" column is too long to

display following columns in the dialog. Unfortunately, the dialog does

not support scroll horizontally. As the result, I can't view and edit those

columns... See attached image. Wondering is there any way that I can

customise the size of this dialog or enable horizontal scroll for the dialog.

 

Any suggestion would be appreciated.

 

Thanks very much in advance.

 

Best,

 

Sc

5 Replies
Highlighted

@Hare0319 The picture you uploaded suggests that your "Current selection" does not contain any CF rules. Change to "This worksheet" at the top in stead, or select the range for which you want to edit the rules first. Then press the CF button to see the active rules for that range.

Highlighted

@Riny_van_Eekelen 

Thanks very much for your reply.

Yes, the image I uploaded is from a blank workbook. That's why there's no active

conditional format. But as we can see from the image, there's only three columns

displayed, "Rule, Format, Applies to". And the Applies to column is really close to

the right border of the dialog. And there's no enough HORIZONTAL space for 

“Applies to" and "Stop if True".

 

Best,

 

sc

Highlighted

@Riny_van_Eekelen I've updated the image, which contains a CF rule. Please have a look, from this image you can see that the "Applies to" is not displayed completely.

 

Thanks very much.

 

Best,

 

sc

Highlighted

@Hare0319 Ah, I see. Then I'm not able to help you. Sorry.

Highlighted
Thanks very much anyway. No worries.