Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Number Formatting
Hi,
I need to number format a group of cells based on the number contained in another cell. In other words, if the value in A1 is 1 I need to format A2 to D2 as percent, if the value in A1 is 0 I need to format A2 to D2 as a number. From, trying to figure out how t odo it I gathered that conditional formatting will not be able to do it, and I don't know how to write a macro to do it so any help will be appreciate it. Thanks in advance. Neda |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Number Formatting
one way:
Put this in your worksheet code module (right-click the worksheet tab an choose View Code): Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Not Intersect(Target, Range("A1")) Is Nothing Then _ Range("A2:D2").NumberFormat = _ IIf(Range("A1").Value = 1, "0%", "0.00") End Sub Adjust the formats as desired. In article , "Neda" wrote: Hi, I need to number format a group of cells based on the number contained in another cell. In other words, if the value in A1 is 1 I need to format A2 to D2 as percent, if the value in A1 is 0 I need to format A2 to D2 as a number. From, trying to figure out how t odo it I gathered that conditional formatting will not be able to do it, and I don't know how to write a macro to do it so any help will be appreciate it. Thanks in advance. Neda |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Number Formatting
Works greatly.
Thanks. "JE McGimpsey" wrote: one way: Put this in your worksheet code module (right-click the worksheet tab an choose View Code): Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Not Intersect(Target, Range("A1")) Is Nothing Then _ Range("A2:D2").NumberFormat = _ IIf(Range("A1").Value = 1, "0%", "0.00") End Sub Adjust the formats as desired. In article , "Neda" wrote: Hi, I need to number format a group of cells based on the number contained in another cell. In other words, if the value in A1 is 1 I need to format A2 to D2 as percent, if the value in A1 is 0 I need to format A2 to D2 as a number. From, trying to figure out how t odo it I gathered that conditional formatting will not be able to do it, and I don't know how to write a macro to do it so any help will be appreciate it. Thanks in advance. Neda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Conditional Formatting | Excel Worksheet Functions |