I can use conditional formatting to change the shading dependent on it's value.


How can I do conditional formatting based upon another cell.

e.g. I want to shed column D dependent on the value in column C.

Any suggestions ?