Format/Conditional Formatting. Select Formula Is, =$A$1=1, then click format
and select your color. When 1 is input into A1, your cell will change color.



" wrote:

Is there away to change the colour of a cell given a specific input.
Depending on the value a user gives in a cell, I'd like to
correspondingly change the colour.

I am assuming there is a straightforward way to test inputs and
correspondingly change the settings of a cell and ideally a couple of
other cells.