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

  • Thread starter Thread starter Lainey25
  • Start date Start date
L

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
 
Back
Top