View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Khusro Khusro is offline
external usenet poster
 
Posts: 8
Default If function with format

=if(a10,a1,"")
A1 "text" or "number" in red color
I want to print the value of cell A1 in Cell B1 with its format if above
condition is true. Is it possible ?