Delete More than 100 , #REF! Error in Conditional formatting Manage Rule by Single click.

DIPANKAR SARKAR 0 Reputation points
2024-11-16T05:28:26.6366667+00:00

Dear Sir,

How can I bulk delete #REF! Error in Conditional formatting Manage Rule at a time; it's much more time-consuming to delete one by one.

It became my worksheet slower. So please prove any shortcut for deleting this type of #REF! Error

Conditional Formatting at a single Click.Screenshot (63)

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,299 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
10,177 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.