Conditional Formatting based on entire column
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.
|