|
||
|
Techie Corner Ask/Answer computer questions |
Thread Tools | Search this Thread | Display Modes |
#1
|
||||
|
||||
Microsoft Excel ?
Is there a way to make colors show up when it reaches a certain number. For example. If it hits 2% it will turn to green. if it hits 6% it will turn red. Is there a formula I can write to do this? If so could ya show me. Thank you
__________________
June 08 Pick10 Winner July 08 Monthly Winner July-Sep 08 Quarterly Winner July 12 Monthly Winner July 12 Pick 10 Winner Aug 12 Monthly Winner |
#2
|
||||
|
||||
I think you can do that with the conditional formatting option.
I have Excel 2007 and there is a conditional formatting button on the main bar, select that and you then can select the conditions and the colors you would like the cell(s) to change when the value changes. |
#3
|
||||
|
||||
Thank you soooo much. That was huge.
__________________
June 08 Pick10 Winner July 08 Monthly Winner July-Sep 08 Quarterly Winner July 12 Monthly Winner July 12 Pick 10 Winner Aug 12 Monthly Winner |
#4
|
||||
|
||||
Conditional formatting has its uses for sure (my Projinator file has a ton of it)....just be forewarned, what's done in 2007 is not all compatible in 2003 (or at least I think that's part of what 2003 users don't see in my Projinator)
__________________
Find us on for updates, including site issues. Also now on Reddit, not that I'm sure what we're doing there yet. Don't piss off old people- the older we get, the less life in prison is a deterrent. I'm pretty confident my last words will be 'well crap, that didn't work'. Of all the things I've lost over the years, I think I miss my metabolism most of all. Nachos are just tacos that don't have their s_it together. I'm not adding this year to my age because I really didn't use it. Ever notice that extra fries and exercise sound a lot alike? |
#5
|
||||
|
||||
well ----. I have 2003. No wonder why your formulas are off.
__________________
June 08 Pick10 Winner July 08 Monthly Winner July-Sep 08 Quarterly Winner July 12 Monthly Winner July 12 Pick 10 Winner Aug 12 Monthly Winner |
#6
|
||||
|
||||
my formulas are off? where?
Projinator is saved in 2003 formed...so it's just some features that may not work, not anything that should be incorrect
__________________
Find us on for updates, including site issues. Also now on Reddit, not that I'm sure what we're doing there yet. Don't piss off old people- the older we get, the less life in prison is a deterrent. I'm pretty confident my last words will be 'well crap, that didn't work'. Of all the things I've lost over the years, I think I miss my metabolism most of all. Nachos are just tacos that don't have their s_it together. I'm not adding this year to my age because I really didn't use it. Ever notice that extra fries and exercise sound a lot alike? |
#7
|
||||
|
||||
okay I need some help with "IF" formulas. Can someone message me please if your a GOD at excel an willing to assist me. Thank you.
__________________
June 08 Pick10 Winner July 08 Monthly Winner July-Sep 08 Quarterly Winner July 12 Monthly Winner July 12 Pick 10 Winner Aug 12 Monthly Winner |