How can I make the 2 cells answer to my formula, make another non-related
field change color to reflect the color-coded answer? i.e. cells: a1+b1=c1,
but I want the color in d1 to be the color to reflect the answer in c1; red,
yellow or green.

I know to put the formula in c1 to: =sum(a1+b1).....this is not, of course
doing anything for me in d1....Any Ideas???

Another issue, non-related: how can I get info from a single cell, in a huge
workbook page, from a multi-page workbook, into my current sheet? i.e. cell
a1 needs the info from another workbook cell a1, page 17, of multiple pages
type workbook, into new page cell r5?

Sorry in advance for the amount of text here.