| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting cells
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formatting cells
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formatting cells
Thanks
On Fri, 12 Nov 2004 12:45:02 -0800, "Jim Thomlinson" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formatting cells
=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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formatting cells
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| condionally formatting based on another cells formatting? | Excel Discussion (Misc queries) | |||
| conditionally formatting cells based on other cells | Excel Discussion (Misc queries) | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Help formatting cells | Excel Worksheet Functions | |||
| Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
Linear Mode
