Thread: mark just cells containing data in a range
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Mark Lincoln Mark Lincoln is offline
external usenet poster
  
Posts: 227
Default mark just cells containing data in a range
I seem to have used a couple of extra parentheses. This CF formula
works just as well:

=NOT(ISBLANK(A1))

Reply With QuoteReply With Quote