Results 1 to 8 of 8

Thread: Shade all Blank rows in Range

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 04-03-2007, 12:30 PM #1
    lenze
    lenze is offline
    VBAX Regular
    Joined
    Mar 2005
    Location
    Helena, MT
    Posts
    90
    Location
    Why not use CF
    Select the entire sheet with A1 active. In CF, choose "Formula Is" option
    =COUNTA(A1:IV1)=0
    If you only use columns A:R then change it to
    =COUNTA(A1:R1)=0
    lenze
    Last edited by Aussiebear; 02-05-2025 at 12:27 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules