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

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

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

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