How to highlight cells...

M

Mare

Hi,
I would like to know, is it possible to highlight all the cells that
are used in formula by simple selecting of the formula result cell (I
would like to see which cells are included in the formula). Solution
must be somewhere in "conditional formatting", but I can not find it.
Please direct me where to look for the solution.
Thanks in advance.
 
U

Ubsy

If you double click on the result cell, it will highlight those cell
used in the formula.

Cheers
Ubs
 
M

Mare

Thanks for the quick reply,
I did not explain that I would like to have highlighted cells color
coded, and also to be able to select different result cells within the
same worksheet at the same time.
 
B

Bob Phillips

Create a UDF

Function IsFormula(rng As Range)
IsFormula = rng.HasFormula
End Function

and use that in conditional formating to highlighte them.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if both cells are same highlight 2
formula to find cell values containing X 2
Trying to highlight cells 1
Excel VBA 1
Conditional Formatting - find cells containg "+" 3
Creating a formula to highlight a row of cells 3
Highlight MAX Cell Greater Than Zero 4
can conditional formatting varry the area it highlights based on c 3

Top