Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Default to zero currency value
I have a document that I need to default to a zero currency value, however if
there is a value in cell B100 in the "Data Input" sheet which is in the same workbook, I need that value to prefill into this cell. How can I code this with a function? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Default to zero currency value
Select the range to which you want to apply this conditional formatting, and
then select Format--Conditional formatting. In the first condition shown in the dialogue box, enter the following formula: =B100 If you want the values in this range to be zero, then enter 0 in B100, else, whatever other value you want in this range can be entered into B100. -- Brevity is the soul of wit. "SITCFanTN" wrote: I have a document that I need to default to a zero currency value, however if there is a value in cell B100 in the "Data Input" sheet which is in the same workbook, I need that value to prefill into this cell. How can I code this with a function? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default settings for currency | Setting up and Configuration of Excel | |||
changing default currency in balance sheet | Excel Discussion (Misc queries) | |||
Change the default Currency style | Setting up and Configuration of Excel | |||
im trying to change the default currency for my excel from $ to M. | Excel Discussion (Misc queries) | |||
Default Currency | Excel Discussion (Misc queries) |