Can I put a formula into a cell that makes a bunch of cells change color without using VBA? I'm leaning towards no but I'm not positive.

10/2/2007 6:54:22 PM

no

10/2/2007 6:54:39 PM

i seem to recall having done this before.

i dont remember for sure, though



[Edited on October 2, 2007 at 7:32 PM. Reason : ]

10/2/2007 7:31:32 PM

VBA IS YOUR FRIEND

10/2/2007 7:31:58 PM

You can set up cells to change colors when they fit certain parameters. For instance if you had a spreasheet of rainfall events, you could set it up so that all events over 1 inch could be shaded green and all events less that .25 inch could be red.

Not sure if that helps...

10/2/2007 8:01:09 PM

?topic=494223

10/2/2007 8:02:52 PM

YES, CONDITIONAL FORMATTING ON THE OTHER CELLS

10/2/2007 8:20:15 PM

^he helped me do it before.

10/2/2007 8:24:35 PM

Condition Formatting, especially if you use the "Formula" option, is very powerful

10/2/2007 8:31:39 PM