Hi there ... I want to be able to format an entire row of data by
highlighting it a specific colour (say C1 to C10) based on the value of only
one cell (say C10). Conditional Formatting doesn't appear to work for this,
because it only looks at the value in one cell and formats that same cell.
And I'm not sure how to write an if statement where the result is to format a
cell with a colour.

Is there a way to do this?

Thanks!