2006-06-21 06:45:07 · 4 answers · asked by timcfa 2 in Computers & Internet ➔ Software
If you are talking about "color-coded cell references" aimed at another sheet in the workbook, I have never been able to do this myself. Even Go to... does not work to another sheet.
The closest I have ever been able to come is turning off in-cell editing (Tools | Options | Edit | uncheck "Edit directly in cell) and double-clicking on the cell that contains the formula; this takes you to the first cell referenced in the formula.
2006-06-21 07:02:02 · answer #1 · answered by O Caçador 6 · 0⤊ 0⤋
The formula in one cell is a static formula (meaning it doesn't change) So, let's say that formula is in A1. In your other cells, you can reference that cell for the result. So: A1: =5+5 (or whatever your formula is) in any other cell, make it reference A1, so if you have values in B1, C1 and D1, say in A2 you can enter =sum(B1:D1)*A1. Which first adds the values in B1, C1 and D1, then multiplies that sum by the value in A1 (in this example, 10). There are, of course, many ways of doing the cell references, and this is a very simple example. Hope this helps, but let me know if you have a specific scenario you want to apply this to.
2016-05-20 09:13:32 · answer #2 · answered by Anonymous · 0⤊ 0⤋
Highlight the cells - go to format - cells - borders tab- pick the line style you want for the border - now go below that to color- it will say automatic - click on it and the color wheel will come up - pick a color then click ok.
2006-06-21 06:51:59 · answer #3 · answered by lsnelson50 1 · 0⤊ 0⤋
Tried conditional formatting? You need to specify how you format the cells & that's it :)
2006-06-21 06:48:48 · answer #4 · answered by Capndon 2 · 0⤊ 0⤋