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

[Lainey25]

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

 

[Jacob Skaria]

You can acheive this using Conditional formatting. Refer

http://www.contextures.com/xlCondFormat01.html