Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

A tool is needed for auditing Conditional Formatting formulae

Conditional formatting allows a formula as part of a rule, and that formula may refer to another cell in the workbook. If that other cell is deleted, then a #REF error creeps into the conditional formatting formula.
Of course a properly constructed formula would allow for such circumstances, but there is no simple method to check the conditional formatting rules to validate them.
It would be helpful to have a way to download the conditional formatting rules to allow the programmer to audit those rules.

3 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Ian Pugsley shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
An error occurred while saving the comment

Feedback and Knowledge Base