Trace Dependents - Conditional Formatting

[ionelz]

Hi,
I have many pages in my workbook.
How to Conditional Formatting all cells in Tab Page1 which are used in entire workbook
I am referring to Formulas-Trace-Dependents

Example, A1=20
I want to conditional formatting cell A1 because is used in other Tabs
Thank you

 

[6StringJazzer]

Let me rephrase to make sure your question is clear.

You have multiple worksheets in your workbook.
The worksheet Page1 has many cells which are referenced by formulas in other worksheets.
You want to format all cells on Page1 that are referenced by formulas in any worksheet, including Page1.

Example:
Page2!B2 is

=Page1!A1*2

Highlight Page1!A1

Excel does not have a function available to worksheet formulas that will tell you if a cell is referenced by a formula in another cell. You would need a bit of VBA using the Dependents method to do something like this. I don't know if you were expecting that so I'm not going to even start on a solution if you can't use it.

 

[6StringJazzer]

Thanks for the Like but do you want a VBA solution?

 

[ionelz]

Thanks for the Like but do you want a VBA solution?

yes, if you could post a vba solution for this, yes.