Cool. You learn something new every day. Thanks Bob...

"Bob Phillips" wrote:

=C3="Tada" is enough as that returns True or False

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jim Thomlinson" wrote in message
...
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