Jump to content

Any Excel Wizards on here?


AC66Bronco

Recommended Posts

Here is what I am trying to do.

 

I am trying to make cell colors change if a data source is changed from a different value. The problem is that the data source will never be the same.

 

For instance if the data source is 5 and you change it to say 4 I want any cells that are linked to the source cell of 5 to change to a different color. But it won’t always be 5.

 

 

Anyone got any ideas?

 

Been messing around with conditional formatting.

Link to comment
Share on other sites

Conditional Formatting > Highlighting Cell Rules > Format only cells that contain cell value equal to...then select a cell?

 

right but everything is going to be constantly changing. this is for a financial application.

 

what would i set the cell equal to if for instance 5 is not always going to be 5 it could be 50000000000000000

 

maybe i am confused.

Link to comment
Share on other sites

Your question's got me confused. Lettuce say that you have a set of values in your B column and some of these values in the column play a part of an equation in the C column. You want column C cells to change color if thevalues change as a result of the value in B being changed?

 

I guess if I am understanding that correctly I don't see the point. Anyway, Greg's close but you want to use "What-if Analysis" not conditional formatting.

Link to comment
Share on other sites

So you are saying is you want 5 to be red for all the cells associated with it and have them all turn blue if you change the 5 to 4? Is the value of the associated cells going to change as well or just the primary source(5)?

 

If you change the value of the 5 and it is a part of the other formulas it will be the same

 

 

:dumb:

Link to comment
Share on other sites

If you change the value of the 5 and it is a part of the other formulas it will be the same

 

 

:dumb:

 

Not if 5 in intself is its own formula thats formatted in a way to reflect different values based on whats entered. I have similar ones Ive had to make for work over the years.

Link to comment
Share on other sites

Your question's got me confused. Lettuce say that you have a set of values in your B column and some of these values in the column play a part of an equation in the C column. You want column C cells to change color if thevalues change as a result of the value in B being changed?

 

I guess if I am understanding that correctly I don't see the point. Anyway, Greg's close but you want to use "What-if Analysis" not conditional formatting.

 

DING WINNER!!!!!

 

However column b will almost never have the same values.

 

starting to think macro...

Link to comment
Share on other sites

DING WINNER!!!!!

 

However column b will almost never have the same values.

 

starting to think macro...

 

What exactly do you need to highlight the change for? I'm just thinking out loud here but when I am doing accounting work and I change a number, I already have foresight of what's going to change as a result. Are you running scenarios? I mean, are you changing this number and trying to see what input yields a certain result? If so, use goal seek under what-if analysis. If you're running multiple scenarios, I would create a data table.

 

Brian you and I were on the right/same page I was just being a dick, sorry.

Link to comment
Share on other sites

What exactly do you need to highlight the change for? I'm just thinking out loud here but when I am doing accounting work and I change a number, I already have foresight of what's going to change as a result. Are you running scenarios? I mean, are you changing this number and trying to see what input yields a certain result? If so, use goal seek under what-if analysis. If you're running multiple scenarios, I would create a data table.

 

Brian you and I were on the right/same page I was just being a dick, sorry.

 

Its all fun...but you did make me read over it like 5000 times to see if I messed up on my explanation :lol:

Link to comment
Share on other sites

What exactly do you need to highlight the change for? I'm just thinking out loud here but when I am doing accounting work and I change a number, I already have foresight of what's going to change as a result. Are you running scenarios? I mean, are you changing this number and trying to see what input yields a certain result? If so, use goal seek under what-if analysis. If you're running multiple scenarios, I would create a data table.

 

Brian you and I were on the right/same page I was just being a dick, sorry.

 

It is more for training new ppl so they can see that it changed.

 

Ill have to read up on the goal seek and what if analysis. me no good with them lol

 

TY very much!:megusta:

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...