VBA to recurse sheets and find errors in formulas and cond formatting?

[leaning]

Hello!

Is there any easier way to open a workbook and then go through each sheet of the workbooks pointing out any cells that have #REF and other errors in their formulas or in the formulas associated with conditional formatting?

The ones that result in an overall cell error are usually fairly easy to see, but the ones that have cond formatting formulas with errors I usually can't find unless I go through each cell on each sheet.

??

Thanks for your help!

VR/Lost