Home
Portfolio
Market
Market2
Leaders
Pick'em
Messenger
Oasis

Go Back   Jockstocks Forums > Non Sports Related > Techie Corner
FAQ Calendar Search Today's Posts Mark Forums Read

Techie Corner Ask/Answer computer questions

Reply
Thread Tools Search this Thread Display Modes
  #1  
Unread 07 Jun 2012, 09:02 PM
ibzilly ibzilly is offline
All Pro
 
Join Date: Mar 2007
Posts: 621
Default 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  
Unread 08 Jun 2012, 04:48 PM
SayOw SayOw is offline
Hall of Famer
 
Join Date: Mar 2007
Location: The Barren Wasteland
Posts: 1,218
Send a message via ICQ to SayOw Send a message via MSN to SayOw Send a message via Yahoo to SayOw
Default

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  
Unread 09 Jun 2012, 10:59 AM
ibzilly ibzilly is offline
All Pro
 
Join Date: Mar 2007
Posts: 621
Default

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  
Unread 09 Jun 2012, 05:46 PM
SiteWolf SiteWolf is offline
JSAdmin
 
Join Date: Mar 2007
Location: Just south of sane
Posts: 18,219
Send a message via Skype™ to SiteWolf
Default

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  
Unread 12 Jun 2012, 10:32 AM
ibzilly ibzilly is offline
All Pro
 
Join Date: Mar 2007
Posts: 621
Default

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  
Unread 12 Jun 2012, 01:19 PM
SiteWolf SiteWolf is offline
JSAdmin
 
Join Date: Mar 2007
Location: Just south of sane
Posts: 18,219
Send a message via Skype™ to SiteWolf
Default

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  
Unread 17 Jun 2012, 12:56 PM
ibzilly ibzilly is offline
All Pro
 
Join Date: Mar 2007
Posts: 621
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 06:14 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
© 2007 - 2011 Jockstocks
Jockstocks Forums Database Error
Database Error Database error
The Jockstocks Forums database has encountered a problem.

Please try the following:
  • Load the page again by clicking the Refresh button in your web browser.
  • Open the forums.jockstocks.com home page, then try to open another page.
  • Click the Back button to try another link.
The forums.jockstocks.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.