PC Review


Reply
Thread Tools Rate Thread

how do i automate colour to fill a cell if a range of data is inp

 
 
Lainey25
Guest
Posts: n/a
 
      18th Jun 2009
I would like for a cell to automatically fill with a colour if numbers 1-3
are entered into the cell. Then another colour if numbers 4-6 are entered,
and yet another if 7-9 is entered.

can anyone help?

Thanks
 
Reply With Quote
 
 
 
 
Jacob Skaria
Guest
Posts: n/a
 
      18th Jun 2009
You can acheive this using Conditional formatting. Refer

http://www.contextures.com/xlCondFormat01.html
--
If this post helps click Yes
---------------
Jacob Skaria


"Lainey25" wrote:

> I would like for a cell to automatically fill with a colour if numbers 1-3
> are entered into the cell. Then another colour if numbers 4-6 are entered,
> and yet another if 7-9 is entered.
>
> can anyone help?
>
> Thanks

 
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
Changing fill colour of cells in a range Paul Hyett Microsoft Excel Misc 8 14th Jul 2007 07:04 PM
if cell colour is then change cell colour in range =?Utf-8?B?dGlnZXI=?= Microsoft Excel Programming 2 30th May 2007 05:32 AM
Fill a cell with a data range =?Utf-8?B?RGVlZHM=?= Microsoft Excel Programming 1 19th Dec 2005 10:14 PM
Change cell colour for a cell or range within a predefined range =?Utf-8?B?TWFydGlu?= Microsoft Excel Programming 2 23rd May 2005 06:16 PM
Colour fill within a range Paul Watkins Microsoft Excel Misc 1 28th Jan 2004 03:32 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:48 AM.