Small Excel Question Not Worth Its Own Thread

Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread

Frost -273: Nov 26, 2004

Is there a way to color cels that are used in a formula?

For example in =SUM(A1,A3,A4) I want each cel, included in the formula, to change to green so I know I have used them.

I have another formula =SUM(A2,B2,D11) I want these to turn red.

When I double click on a cell with a formula it put an outline round the reference cell but won't let me color then. How do I do this?

I have a lot of sum formulas in this sheet and I need to know what I have added and what is unused.

I have been googling for about 45 minute but still can't work it out.

# ¿ Dec 2, 2010 11:05

Adbot: ADBOT LOVES YOU

# ¿ May 8, 2024 08:21

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread