PC Review


Reply
Thread Tools Rate Thread

How can I set a cell to conditionally change background color?

 
 
=?Utf-8?B?YnJpZ2h0QmlsbA==?=
Guest
Posts: n/a
 
      2nd Apr 2007
This may be too easy, but I can't figure out how to set up a cell to change
background colors (red/yellow/green) based on the numeric value it contains.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?V29vZCBHcmFmaW5n?=
Guest
Posts: n/a
 
      2nd Apr 2007
Look in the Excel help for Conditional Formatting. Or you can look here:
http://www.cpearson.com/excel/cformatting.htm

--
Anything is possible if you don''t know what you''re talking about.


"brightBill" wrote:

> This may be too easy, but I can't figure out how to set up a cell to change
> background colors (red/yellow/green) based on the numeric value it contains.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Any method to set cell background color conditionally ? come_mon_come_mon! Microsoft Excel Misc 2 14th Apr 2007 12:34 PM
Any method to set cell background color conditionally ? come_mon_come_mon! Microsoft Excel Worksheet Functions 2 14th Apr 2007 12:34 PM
how can I conditionally change font color, or background color? =?Utf-8?B?TU9IQQ==?= Microsoft Excel Worksheet Functions 6 21st Aug 2006 06:57 PM
how can I conditionally change font color, or background color? =?Utf-8?B?TU9IQQ==?= Microsoft Excel Worksheet Functions 0 21st Aug 2006 06:43 PM
Conditionally setting background color of a cell Scott Steiner Microsoft Excel Misc 1 20th Nov 2005 12:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:58 AM.