Sep 20 2020 08:41 PM - edited Sep 20 2020 11:10 PM
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
Sep 20 2020 09:44 PM
@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.
Sep 20 2020 11:18 PM
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
Sep 20 2020 11:26 PM
@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
Sep 20 2020 11:28 PM
@Hare0319 Ah, I see. Then I'm not able to help you. Sorry.