Thread: Conditional Format - formula = 0 vs. entering zero
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ed Ferrero[_3_] Ed Ferrero[_3_] is offline
external usenet poster
  
Posts: 108
Default Conditional Format - formula = 0 vs. entering zero
Hi Sheeloo,

Can you use Get.Cell directly in a cell like this in B1
=SUMPRODUCT(--(XLM.GET.CELL(18,C1:C10)="Arial"))

No - you cannot :(

Ed Ferrero
www.edferrero.com
Reply With QuoteReply With Quote