View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] amorrison2006@googlemail.com[_2_] is offline
external usenet poster
 
Posts: 53
Default 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