| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help on a formula
You are welcome! Thanks for the feedback!
Stefi WYN ezt *rta: hi stefi, thank you, that works just fine. wyn. -- wynb "Stefi" wrote: Hi WYN, Apply this event macro: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 And Target.Value = "open" Then Range("B" & Target.Row).Value = 0 Range("B" & Target.Row).NumberFormat = "[$$-409]##,#00.00" End If End Sub Post if you need help to install it! Regards, Stefi WYN ezt *rta: hello all, i have a database with all my invoices and their dollar totals in column b.what i want to do is if in colunm a1 i enter the word open then the corresponding invoice total b1 will be $00.00.any help will be appreciated.thanks wyn -- wynb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
