Forum Discussion

Hare0319's avatar
Hare0319
Copper Contributor
Sep 21, 2020

Issue about CF rules manager dialog

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

excel
office 365

5 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Sep 21, 2020

    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.

    • Hare0319's avatar
      Hare0319
      Copper Contributor
      Sep 21, 2020

      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

    • Hare0319's avatar
      Hare0319
      Copper Contributor
      Sep 21, 2020

      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

Resources