I would like a cell automatically formatted in the same way a conditional
format works - but the format to be based on the value of an adjacent cell.

Any ideas as I cant work out how or if I can achieve this