Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

Coloring a Cell

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
OlYeller21 - 18 Jul 2006 14:28 GMT
Is there any way to make a cell turn a different color when the value in
it is something?  I have a bunch of scores being calculated and I want
anything lowed than 80% to be tunred yellow and anything below 60% to
be turned red.  I have some programming knowledge and I'm willing to
learn.  Thanks
Zach

Signature

OlYeller21

JE McGimpsey - 18 Jul 2006 14:37 GMT
Check out "Conditional Formatting" in XL Help.

In article <OlYeller21.2b57w2_1153229404.8151@excelforum-nospam.com>,
OlYeller21 <OlYeller21.2b57w2_1153229404.8151@excelforum-nospam.com>
wrote:

> Is there any way to make a cell turn a different color when the value in
> it is something?  I have a bunch of scores being calculated and I want
> anything lowed than 80% to be tunred yellow and anything below 60% to
> be turned red.  I have some programming knowledge and I'm willing to
> learn.  Thanks
> Zach
patele - 18 Jul 2006 15:24 GMT
Use conditional formatting.

Go to Format>Conditional Formatting:
First Block: Select Cell Value Is
Second Block: Select between
Third Block: enter 0
Forth Block: enter 0.59
Select Format
Select Patterns and click on Red
Click on OK

Click on Add>> at the bottom
Follow the above except in the Third Block this time enter 0.6 and in
the Forth Block enter 0.79
Select Format
Select Patterns and click on Yellow
Click on OK
Click on OK again.

Make sure the cells you're formatting are formatted as %.

Signature

patele

OlYeller21 - 19 Jul 2006 14:18 GMT
Hey, thank you, that worked perfectly.
Zac

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.