Yup...
Select the cell you want to highlight (conditionally). In the format menu
there is an option for conditional formatting. The conditional formatting
form allows you to specify a cell value or a formula. In your case you will
want a formula such as
=if(C3="Tada", true, false)

In the form you will also have to choose the format that you want to apply.

This format can be copied and pasted like any other format.

" wrote:

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