How to highlight cells...
 

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.


--
Mare
------------------------------------------------------------------------
Mare's Profile: http://www.excelforum.com/member.php...o&userid=27644
View this thread: http://www.excelforum.com/showthread...hreadid=505994

How to highlight cells...
 

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

Cheers
Ubsy


--
Ubsy
------------------------------------------------------------------------
Ubsy's Profile: http://www.excelforum.com/member.php...o&userid=30921
View this thread: http://www.excelforum.com/showthread...hreadid=505994

How to highlight cells...
 

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.


--
Mare
------------------------------------------------------------------------
Mare's Profile: http://www.excelforum.com/member.php...o&userid=27644
View this thread: http://www.excelforum.com/showthread...hreadid=505994

How to highlight cells...
 

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)

"Mare" wrote in message
...

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.


--
Mare
------------------------------------------------------------------------
Mare's Profile:
http://www.excelforum.com/member.php...o&userid=27644
View this thread: http://www.excelforum.com/showthread...hreadid=505994