Formatting cells

  • Thread starter Thread starter martin
  • Start date Start date
M

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
 
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.
 
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.
Click to expand...
 
=C3="Tada" is enough as that returns True or False

--

HTH

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