| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statements resulting in formatting of cells
Is there a way to create a IF statement that results in the cell format
changing? For example, if the resulting value is True than the cell turns blue, if False then the cell turns red? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statements resulting in formatting of cells
Hi,
Yes there is but without more detail providing a formula is difficult but the answer lies in conditional formatting. Mike "Jen" wrote: Is there a way to create a IF statement that results in the cell format changing? For example, if the resulting value is True than the cell turns blue, if False then the cell turns red? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statements resulting in formatting of cells
Check out FormatConditional Formatting
Gord Dibben MS Excel MVP On Wed, 15 Oct 2008 08:07:02 -0700, Jen wrote: Is there a way to create a IF statement that results in the cell format changing? For example, if the resulting value is True than the cell turns blue, if False then the cell turns red? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statements resulting in formatting of cells
Hi,
1. Select the cell or range of cells 2. Choose Format, Conditional Formatting 3. From the second drop down pick equal to 4. In the next box type TRUE 5. Click the Format button to the right 6. Select the Patterns tab and a blue color, then click OK twice. -- Thanks, Shane Devenshire "Jen" wrote: Is there a way to create a IF statement that results in the cell format changing? For example, if the resulting value is True than the cell turns blue, if False then the cell turns red? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting with IF statements | Excel Discussion (Misc queries) | |||
| Formatting and IF Statements | Excel Worksheet Functions | |||
| How to split Cell content into two resulting cells | Excel Worksheet Functions | |||
| Nesting IF statements, Conditional Formatting | Excel Discussion (Misc queries) | |||
| when adding cells resulting from tax calulations they do not equa. | Excel Discussion (Misc queries) | |||
Linear Mode
