Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
set formatting without using Conditional Formatting
I'm trying to set formatting with a function, and not with conditional
formatting. =IF(A10,A1,B1) What I want =IF(A10,A1 [font on bold blue],B1 [font in black]) I realize that this could be done with Conditional Formatting, but the actual function is significantly more complex. Any solutions or "Can't be done" are welcome. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
set formatting without using Conditional Formatting
Conditional formatting, manual formatting, or VBA code are your 3 choices.
Formulas alone cannot set formatting attributes. Oh, there is a 4th choice: using color codes in your numeric formatting strings, e.g. [red] "Chris T-M" wrote: I'm trying to set formatting with a function, and not with conditional formatting. =IF(A10,A1,B1) What I want =IF(A10,A1 [font on bold blue],B1 [font in black]) I realize that this could be done with Conditional Formatting, but the actual function is significantly more complex. Any solutions or "Can't be done" are welcome. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
set formatting without using Conditional Formatting
I'm not sure what you mean by
"...using color codes in your numeric formatting strings, e.g. [red]" Would you provide a simple code example? "Duke Carey" wrote: Conditional formatting, manual formatting, or VBA code are your 3 choices. Formulas alone cannot set formatting attributes. Oh, there is a 4th choice: using color codes in your numeric formatting strings, e.g. [red] "Chris T-M" wrote: I'm trying to set formatting with a function, and not with conditional formatting. =IF(A10,A1,B1) What I want =IF(A10,A1 [font on bold blue],B1 [font in black]) I realize that this could be done with Conditional Formatting, but the actual function is significantly more complex. Any solutions or "Can't be done" are welcome. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
set formatting without using Conditional Formatting
Oh, there is a 4th choice: using color codes in your numeric formatting
strings, e.g. [red] I thought that didn't work? I could swear I've tried before, and failed. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
set formatting without using Conditional Formatting
See John McGimpsey's site for custom formatting up to 6 colors.
http://www.mcgimpsey.com/excel/conditional6.html Gord Dibben MS Excel MVP On Wed, 29 Oct 2008 13:35:04 -0700, Chris T-M wrote: I'm not sure what you mean by "...using color codes in your numeric formatting strings, e.g. [red]" Would you provide a simple code example? "Duke Carey" wrote: Conditional formatting, manual formatting, or VBA code are your 3 choices. Formulas alone cannot set formatting attributes. Oh, there is a 4th choice: using color codes in your numeric formatting strings, e.g. [red] "Chris T-M" wrote: I'm trying to set formatting with a function, and not with conditional formatting. =IF(A10,A1,B1) What I want =IF(A10,A1 [font on bold blue],B1 [font in black]) I realize that this could be done with Conditional Formatting, but the actual function is significantly more complex. Any solutions or "Can't be done" are welcome. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |