That is not so Mike. As long as the row is relative, you can apply to a
block of rows, I do it all the time.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"mike" wrote in message
oups.com...
On Feb 6, 10:27 am, "Bob Phillips" wrote:
It seems to me that you should select B:M for all desired rows, lets
assume
you start at row 2, and use a CF formula of

=COUNTA($L2:$M2)<0

--
---
HTH

Bob


Instead of blocking all the cells I wanted the format to work on, I
did it on one cell then copied down. Apparently I can't apply to all
cells at once; I must apply to one cell then copy so the formula
adjusts.

It's working now.

Thanks everyone.