Is it possible to format a range of cells to display a certain colour
depending on the text in another cell?

any help greatly appreciated.
Thanks
Martin