View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mike mike is offline
external usenet poster
 
Posts: 24
Default 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.