Conditional formatting

[bailbonds]

Hi,

I have data in cells on various worksheets within 1 workbook. The cells contain formulae that retrieves data from various other cells across the worksheets.

I want to do a type of 'trace precedents' and 'conditional formatting' thing where if I highlight a cell it will trace its precedents to other worksheets and also highlight these cells.

I think what I'm asking for is not possible but would appreciate any help.

Thanks in advance

 

[MickG]

Have a look at MikeRickson's Code Here:-
http://www.vbaexpress.com/forum/showthread.php?t=19348&page=2&highlight=navigate