Home
Portfolio
Market
Market2
Leaders
Pick'em
Pick 10
Messenger
Oasis
Vote

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, 10: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, 05: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, 11: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, 06:46 PM
SiteWolf SiteWolf is offline
JSAdmin
 
Join Date: Mar 2007
Location: Just south of sane
Posts: 15,864
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.

The fact that there is a highway to hell but only a stairway to heaven says a lot about anticipated traffic numbers.
When you're dead, you don't know you're dead. It's only difficult for others. It's the same way when you're stupid.
So, when is this "old enough to know better" thing supposed to kick in?
  #5  
Unread 12 Jun 2012, 11: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, 02:19 PM
SiteWolf SiteWolf is offline
JSAdmin
 
Join Date: Mar 2007
Location: Just south of sane
Posts: 15,864
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.

The fact that there is a highway to hell but only a stairway to heaven says a lot about anticipated traffic numbers.
When you're dead, you don't know you're dead. It's only difficult for others. It's the same way when you're stupid.
So, when is this "old enough to know better" thing supposed to kick in?
  #7  
Unread 17 Jun 2012, 01: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 08:22 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
© 2007 - 2011 Jockstocks