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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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