| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro - If bold then multiply by -1
Hi there
I have number in column A What I want to do is have a macro that can look down the column and if the cell is bold then multiply the contents by -1 in order for me to turn it into a negative figure. I someone can help with this, Thanks Andrea |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alphabetically list of last names: BOLD, not bold | Excel Discussion (Misc queries) | |||
| Alphabetically list of names BOLD and NOT bold | Excel Discussion (Misc queries) | |||
| Join bold and non-bold text in one cell | Excel Discussion (Misc queries) | |||
| Excel macro to multiply by same value | Excel Worksheet Functions | |||
| How to bold a range of cells using macro | Excel Programming | |||
![amorrison2006@googlemail.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
