Excel Question.

EndUnknown · 11-15-2007, 04:47 PM

how would i make it so that if a cell(say h22 for the example) is a specific number(27) the whole sheet changes. Basically I want conditional formating that affects the whole sheet, but only relys on 1 or 2 cells for the conditional formating. on 2007 if it maters.

Super Person · 11-15-2007, 05:06 PM

Put a # in cell A1 for example. then in cell A2, put =A1+1 for a formula. then in cell A3, put A2+1 and so on. the +1 can be anything (like -5, divided by 6, 150% etc.) Then if you change A1, all the other cells will change.

EndUnknown · 11-15-2007, 05:09 PM

no, what I want is a conditional formating where if a cell = a specific # then all the cells get a red fill color

Im making a "who is this" quiz(blurred faces, guess who they are) the formulas are IF(A3="","",IF(A3="Joe","Correct","Incorrect")) the formula may be a little of as its from memory, and for my score keeping I plan to use COUNTIF(A1:J40,"Correct") the score can go to 30, so my plan is to make the whole sheet go red(or other formating) if the score is 30.

Super Person · 11-15-2007, 05:20 PM

Oh, hmmm...I'm not quite sure how to do that.

EndUnknown · 11-15-2007, 05:25 PM

my teacher couldn't even figure that out, but I know its doable as he has a example from a few years ago with it done

Gow616 · 11-17-2007, 03:19 PM

If he has an example see if you can get a copy of that example on a disc/usb stick and transfer to your home computer to mess with and figure it out. Myself I am not an excel aficionado but I am a Power Point Ranger.

shortsleeve · 11-17-2007, 08:59 PM

if you have an example why dont you just view the formulas on the sheet?

Man. · 11-18-2007, 03:42 AM

I'm guessing that your doing some kind of finance sheet.

What you do is go to format->conditional formatting

then change "between" to less then.. then type 0

then format it so if the the cell is below 0 it will turn red. (BTW thats in excel 03)

If i'm doing something complete different, give some more information on what your trying to do.

11-15-2007, 05:06 PM	#2 (permalink)
Super Person Member Join Date: Apr 2007 Location: The Lost City of Atlantis Posts: 641 Reputation: 23	Put a # in cell A1 for example. then in cell A2, put =A1+1 for a formula. then in cell A3, put A2+1 and so on. the +1 can be anything (like -5, divided by 6, 150% etc.) Then if you change A1, all the other cells will change. __________________ To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. Last edited by Super Person : 11-15-2007 at 05:09 PM.

11-15-2007, 05:20 PM	#4 (permalink)
Super Person Member Join Date: Apr 2007 Location: The Lost City of Atlantis Posts: 641 Reputation: 23	Oh, hmmm...I'm not quite sure how to do that. __________________ To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.

11-17-2007, 03:19 PM	#6 (permalink)
Gow616 <Genre Unbound> Support Team Premium Member Section Staff Elite Zuner Join Date: Jan 2007 Location: Fort Wayne, IN, USA Posts: 2,121 Reputation: 588 Awards Showcase Total Awards: 1	If he has an example see if you can get a copy of that example on a disc/usb stick and transfer to your home computer to mess with and figure it out. Myself I am not an excel aficionado but I am a Power Point Ranger. __________________ To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. Gow now ships with Trogdor created profile picture and Munke, STKR, Volpe sig. To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.

11-18-2007, 03:42 AM	#8 (permalink)
Man. Supreme Zune God Support Team Zune Freak Join Date: Aug 2007 Location: United Kingdom Posts: 1,205 Reputation: 82	I'm guessing that your doing some kind of finance sheet. What you do is go to format->conditional formatting then change "between" to less then.. then type 0 then format it so if the the cell is below 0 it will turn red. (BTW thats in excel 03) If i'm doing something complete different, give some more information on what your trying to do. __________________ To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.

11-17-2007, 08:59 PM	#7 (permalink)
shortsleeve Zuner Join Date: Mar 2007 Posts: 57 Reputation: 13	if you have an example why dont you just view the formulas on the sheet?

Advertisement