Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Number formatting?
Hello,
I am curious to know if it is possible to use the conditional formatting to change the number formatting? Currently, I have a sheet that is printed and mailed, but also does calculations. I would like to have the numbers in the calculation change between the number formatting of $###,###,##0and ### ### ##0 $ depending on what is selected in a certain cell. I tried, If(A1=Option 1,text(A2, ### ### ##0 $),text(Text,A2, $###,###,##0) but the number became text and and dependants on A2 would not work. Give the number of cells that I would need to apply this to I was hoping for something more global in nature. Any suggestions would be greatly appreciated. Thanks, Scott |
#2
|
|||
|
|||
conditionaL formating will not change the number format.
You would need a macro to do this "Scott Dawson" wrote: Hello, I am curious to know if it is possible to use the conditional formatting to change the number formatting? Currently, I have a sheet that is printed and mailed, but also does calculations. I would like to have the numbers in the calculation change between the number formatting of $###,###,##0and ### ### ##0 $ depending on what is selected in a certain cell. I tried, If(A1=Option 1,text(A2, ### ### ##0 $),text(Text,A2, $###,###,##0) but the number became text and and dependants on A2 would not work. Give the number of cells that I would need to apply this to I was hoping for something more global in nature. Any suggestions would be greatly appreciated. Thanks, Scott |
#4
|
|||
|
|||
Thanks Earl.
A macro is what I thought I might have to use, but was hoping there might be formula. I appreciate the advice. "Earl Kiosterud" wrote: Scott, I was with you until you said "depending on what is selected in a certain cell." Do you mean "selected" or "contained?" Anyway, Conditional Formatting doesn't change number formatting. There are custom formatting codes that can change number formatting, but only as a function of the contents of the cell itself, not another cell. Probably a macro is the only way. -- Earl Kiosterud www.smokeylake. "Scott Dawson" <Scott wrote in message ... Hello, I am curious to know if it is possible to use the conditional formatting to change the number formatting? Currently, I have a sheet that is printed and mailed, but also does calculations. I would like to have the numbers in the calculation change between the number formatting of "$###,###,##0"and "### ### ##0 $" depending on what is selected in a certain cell. I tried, If(A1="Option 1",text(A2, "### ### ##0 $"),text(Text,A2, "$###,###,##0") but the number became text and and dependants on A2 would not work. Give the number of cells that I would need to apply this to I was hoping for something more global in nature. Any suggestions would be greatly appreciated. Thanks, Scott |
#5
|
|||
|
|||
Thanks for the reply. I am working on the macro now.
"bj" wrote: conditionaL formating will not change the number format. You would need a macro to do this "Scott Dawson" wrote: Hello, I am curious to know if it is possible to use the conditional formatting to change the number formatting? Currently, I have a sheet that is printed and mailed, but also does calculations. I would like to have the numbers in the calculation change between the number formatting of $###,###,##0and ### ### ##0 $ depending on what is selected in a certain cell. I tried, If(A1=Option 1,text(A2, ### ### ##0 $),text(Text,A2, $###,###,##0) but the number became text and and dependants on A2 would not work. Give the number of cells that I would need to apply this to I was hoping for something more global in nature. Any suggestions would be greatly appreciated. Thanks, Scott |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Number formatting?
Scott,
I am having the same problem and was wondering if you can share with me how yuo solved it. Thanks in advance. Neda "Scott Dawson" wrote: Hello, I am curious to know if it is possible to use the conditional formatting to change the number formatting? Currently, I have a sheet that is printed and mailed, but also does calculations. I would like to have the numbers in the calculation change between the number formatting of $###,###,##0and ### ### ##0 $ depending on what is selected in a certain cell. I tried, If(A1=Option 1,text(A2, ### ### ##0 $),text(Text,A2, $###,###,##0) but the number became text and and dependants on A2 would not work. Give the number of cells that I would need to apply this to I was hoping for something more global in nature. Any suggestions would be greatly appreciated. Thanks, Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Not Working Consistently | Excel Discussion (Misc queries) | |||
conditional formatting with formula | Excel Worksheet Functions | |||
Conditional Formatting | Excel Worksheet Functions | |||
Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |