Excel Help - Great Lakes 4x4. The largest offroad forum in the Midwest

Go Back   Great Lakes 4x4. The largest offroad forum in the Midwest > General 4x4 Stuff > The Pub
GL4x4 Live! GL4x4 Casino

The Pub A friendly forum where everybody is nice, and will answer any questions you have about life.

greatlakes4x4.com is the premier Great Lakes 4x4 Forum on the internet. Registered Users do not see the above ads.
Search
Reply
 
Thread Tools Search this Thread
Old April 30th, 2008, 07:01 PM   #1
ElDeeder
Senior Member
 
Join Date: 02-28-07
Location: Oxford, MI
Posts: 171
iTrader: (3)
Mentioned: 0 Post(s)
Default Excel Help

I have to add a couple columns in Excel. Lets say if my answer is 6-7 total i want to shade the box red, but if the answer is 5 or lower I want it to shade the box yellow. Is this possible??

Thanks for the help,
Chris
ElDeeder is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old April 30th, 2008, 07:06 PM   #2
bryanbryan89x
Senior Member
 
bryanbryan89x's Avatar
 
Join Date: 05-02-06
Location: Brighton, MI
Posts: 277
iTrader: (8)
Mentioned: 0 Post(s)
Default

Thats easy, click format, then conditional formatting...
bryanbryan89x is offline   Reply With Quote
Old April 30th, 2008, 07:09 PM   #3
scottie
American Leyland??
 
scottie's Avatar
 
Join Date: 11-05-05
Location: Sweet home Georgia on my mind
Posts: 8,488
iTrader: (2)
Mentioned: 1 Post(s)
Send a message via AIM to scottie
Default

Quote:
Originally Posted by bryanbryan89x View Post
Thats easy, click format, then conditional formatting...
just remember to click the box below to actually change the color, this will save minutes of shouting at the computer as all the values are still black but your formula is correct
scottie is offline   Reply With Quote
Old April 30th, 2008, 07:19 PM   #4
ElDeeder
Senior Member
 
Join Date: 02-28-07
Location: Oxford, MI
Posts: 171
iTrader: (3)
Mentioned: 0 Post(s)
Default

I have that figured out, but i don't have a total column.

I have B12 and C12. what would my formula be for it?

=sum(b12+c12) if the total is less then 6 then font to be red

Keep in mind it all needs to be in column c12.
ElDeeder is offline   Reply With Quote
Old April 30th, 2008, 07:36 PM   #5
rubicon
Senior Member
 
Join Date: 02-27-06
Location: Madison Heights
Posts: 498
iTrader: (2)
Mentioned: 0 Post(s)
Default

replace the + with a : and it will all work
rubicon is offline   Reply With Quote
Reply
Great Lakes 4x4. The largest offroad forum in the Midwest > General 4x4 Stuff > The Pub

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 -5. The time now is 10:36 PM.


Powered by: vBulletin, Copyright 2000 - 2012, Jelsoft Enterprises Ltd.
User Alert System provided by Advanced User Tagging (Lite) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd. Runs best on HiVelocity Hosting.
Page generated in 0.11999 seconds with 36 queries