User not logged in - login - register
Home Calendar Books School Tool Photo Gallery Message Boards Users Statistics Advertise Site Info
go to bottom | |
 Message Boards » » Excel Question Page [1]  
ALkatraz
All American
11298 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
22727 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

 Message Boards » Chit Chat » Excel Question Page [1]  
go to top | |
Admin Options : move topic | lock topic

© 2024 by The Wolf Web - All Rights Reserved.
The material located at this site is not endorsed, sponsored or provided by or on behalf of North Carolina State University.
Powered by CrazyWeb v2.38 - our disclaimer.