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.







Search
Reply
 
Thread Tools
Old April 30th, 2008, 07:01 PM   #1
ElDeeder
Senior Member
 
Join Date: 02-28-07
Location: Oxford, MI
Posts: 171
iTrader: (2)
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
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)
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,481
iTrader: (2)
Send a message via AIM to scottie
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: (2)
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)
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

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 02:50 AM.


Powered by: vBulletin, Copyright 2000 - 2012, Jelsoft Enterprises Ltd.
Copyright 2005 - 2012 Cracker Enterprises - Powered by Linux
vB Ad Management by =RedTyger=
Page generated in 0.08297 seconds with 20 queries