How do I colour an individual cell based on the content
of another cell? Conditional formatting seems only to do
this based on the content of the cell you want to
conditionally colour.

Or have I missed something?

Best wishes,
paul.