View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nospaminlich
 
Posts: n/a
Default Set number format based on cell contents

I have a cell B3 which shows a Data Validation list of £ or %

Having selected £ or % in B3 the user then enters a number in C3. I want to
have cell C3 formatted to General if B3 = % and formatted to Currency if B3 =
£.

I'd really appreciate some help

Thanks