Formatting cells

[martin]

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

 

[Guest]

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.

 

[Tom Ogilvy]

Look at Format=>conditional Format.

 

[martin]

Thanks

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.

 

[Bob Phillips]

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

--

HTH

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

 

[Guest]

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