Trying to find an Excel VBA code that will automatically do the following:
If cell o9 = "410", then go to cell K6 and format it as a whole number; otherwise, format k6 as currency ($) with no cents.
Please note the user will be entering a value into cell k6. I prefer not having the user change the format.
Ideally I thought I could do this in "format-cell-number-custom", but no luck. If I can please let me know-That is my first choice. Note also my conditional formatting does only the color, bold, etc. stuff.
Bookmarks