Filling cells with a colour

I would like to fill say cell A1 with a colour if cell D1 = 3 and a different colour if it =4 and so on

It is very simple really if I enter a number in a cell I want a different cell to change colour

Originally Posted by martindwilson

well conditional formatting will do that for you but you need to expand a bit on what you actually need

only 5

<3 one colour = 3 a different colour and >3 a different colour

Hi Martin worked it out with conditional formatting. Wasn't putting an = before cell. But thanks for taking the trouble to reply