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 |
