Hello,
I would like to format cells based on the value in another cell.
Eg, column A has names of staff. column B gives the score from an assessment.
I would like the name (column A) to change to red if the score in column B is 1. I'd like the name to change to orange if the score in column...