How can I add conditional formatting in a cell that is dependant on another
cell.
Example, If a letter W is entered into cell A6 then cell A10 will
automatically shade in if the entered value in this cell (A10) exceeds 7:50.
If any other letter is entered into cell A6 this rule will not apply.