AC66Bronco Posted October 11, 2011 Report Share Posted October 11, 2011 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. Quote Link to comment Share on other sites More sharing options...
Big Chief2011647545501 Posted October 11, 2011 Report Share Posted October 11, 2011 thats going to be pretty hard to do I'd suggest making it easier and making a macro run on command like alt+W runs macro checking data sources... Quote Link to comment Share on other sites More sharing options...
Gergwheel1647545492 Posted October 11, 2011 Report Share Posted October 11, 2011 if you open the Help in excel and do a search for conditional formatting that should lead you to your answer. Quote Link to comment Share on other sites More sharing options...
AC66Bronco Posted October 11, 2011 Author Report Share Posted October 11, 2011 if you open the Help in excel and do a search for conditional formatting that should lead you to your answer. been there already. Quote Link to comment Share on other sites More sharing options...
CRed05 Posted October 11, 2011 Report Share Posted October 11, 2011 Might have to make 2 sheets. One with the current numbers, and then one with the previous numbers. Quote Link to comment Share on other sites More sharing options...
unfunnyryan Posted October 11, 2011 Report Share Posted October 11, 2011 Conditional Formatting > Highlighting Cell Rules > Format only cells that contain cell value equal to...then select a cell? Quote Link to comment Share on other sites More sharing options...
AC66Bronco Posted October 12, 2011 Author Report Share Posted October 12, 2011 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. Quote Link to comment Share on other sites More sharing options...
Miller Posted October 12, 2011 Report Share Posted October 12, 2011 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. Quote Link to comment Share on other sites More sharing options...
Trouble Maker Posted October 12, 2011 Report Share Posted October 12, 2011 Yeah, I'm not 100% clear on what you are trying to do either, and more importantly why or to what end. Quote Link to comment Share on other sites More sharing options...
V8 Beast Posted October 12, 2011 Report Share Posted October 12, 2011 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)? Quote Link to comment Share on other sites More sharing options...
Miller Posted October 12, 2011 Report Share Posted October 12, 2011 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: Quote Link to comment Share on other sites More sharing options...
DavidBaustert Posted October 12, 2011 Report Share Posted October 12, 2011 macro Quote Link to comment Share on other sites More sharing options...
V8 Beast Posted October 12, 2011 Report Share Posted October 12, 2011 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. Quote Link to comment Share on other sites More sharing options...
Miller Posted October 12, 2011 Report Share Posted October 12, 2011 CIRCULAR WARNING, BATMAN Quote Link to comment Share on other sites More sharing options...
V8 Beast Posted October 12, 2011 Report Share Posted October 12, 2011 (edited) WHAT IF WONDER WOMAN You're reading my post wrong princess. 5 isnt the answer, its the question. Im pretty sure we are saying the exact same thing. Edited October 12, 2011 by V8 Beast Quote Link to comment Share on other sites More sharing options...
Not Brian Posted October 12, 2011 Report Share Posted October 12, 2011 alt-f4 tab enter Quote Link to comment Share on other sites More sharing options...
V8 Beast Posted October 12, 2011 Report Share Posted October 12, 2011 Up up down down left right left right b a Quote Link to comment Share on other sites More sharing options...
AC66Bronco Posted October 12, 2011 Author Report Share Posted October 12, 2011 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... Quote Link to comment Share on other sites More sharing options...
Miller Posted October 12, 2011 Report Share Posted October 12, 2011 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. Quote Link to comment Share on other sites More sharing options...
V8 Beast Posted October 12, 2011 Report Share Posted October 12, 2011 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 Quote Link to comment Share on other sites More sharing options...
BDHG940 Posted October 13, 2011 Report Share Posted October 13, 2011 Up up down down left right left right b a select start Quote Link to comment Share on other sites More sharing options...
AC66Bronco Posted October 13, 2011 Author Report Share Posted October 13, 2011 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: Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.