Fade out Excel cells with errors without using conditional formatting

Question

Is there a way to fade out cells that have errors that doesn't require using conditional formatting?

I have been unable to fix an issue that causes hundreds to thousands of duplicated rules (see this question) so I'm looking for a way to do at least some of my formatting without rules

Answer 1

It would be much simpler to make one conditional formatting rule to fade any cell that is error, such as

=IF(ISERROR(A1),)

and apply it to $A:$XFD, so I'm not sure why you don't want to do that. Maybe there is more to your question then you are supplying.