ALkatraz All American 11299 Posts user info edit post |
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
|
Førte All American 23525 Posts user info edit post |
no 10/2/2007 6:54:39 PM
|
joe_schmoe All American 18758 Posts user info edit post |
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
|
NCSUGimp All American 24387 Posts user info edit post |
VBA IS YOUR FRIEND 10/2/2007 7:31:58 PM
|
Wolfpackman All American 1882 Posts user info edit post |
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
|
joe17669 All American 22728 Posts user info edit post |
?topic=494223 10/2/2007 8:02:52 PM
|
LimpyNuts All American 16859 Posts user info edit post |
YES, CONDITIONAL FORMATTING ON THE OTHER CELLS 10/2/2007 8:20:15 PM
|
humandrive All American 18286 Posts user info edit post |
^he helped me do it before. 10/2/2007 8:24:35 PM
|
agentlion All American 13936 Posts user info edit post |
Condition Formatting, especially if you use the "Formula" option, is very powerful 10/2/2007 8:31:39 PM
|