-1

In the Name Manager, I have a few Table Names defined: A, B, C and D. Now, I want to check which formulas in the current workbook that contain one particular table name, say C. How I can check it apart from opening all formulas via the shortcut Control + ~ (or Ctrl + `)?

Or can I create such a formula via VBA?

Community
  • 1
  • 1
Abhishek Patil
  • 1

1 Answers1

1

Please see images below. I am unable to comment on Ron Rosenfeld's comment due to lack of reputation points. But since that solution is incomplete, I am providing complete solution below.

See sample data taken by me -

enter image description here

Go to Home > Editing > Find & Select > Formulas

enter image description here

It will select formulas. Now go to Home > Styles > Conditional Formatting > EQUAL TO and give the exact data you want to see

enter image description here

enter image description here

Hope it helps.

Ketki
  • 48
  • 6