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.