View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Qaspec Qaspec is offline
external usenet poster
 
Posts: 96
Default Change number property for cell on another sheet

I'd like the number format for the value in cells D1:D30 on sheet2("daily")
to be a general number if a1("data") is empty and i'd like the format to be a
percentage if a1("data") contains a value. This is similiar to a previous
post but this tim the cells are on different sheets.