View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JR JR is offline
external usenet poster
 
Posts: 92
Default value in cell B < value in cell A conditional format

In excell 2007 I have a "=count(C2:BE2)" column and a "=countif(C2:BE2, "
0")" column.

I want to conditional format the count colum if it is less than the countif
column.

When I follow instructions for conditional format to write a formula that is
"true" and enter B < A (or B A) nothing happens.

If I specify the row numbers ( B2 < A2 ) nothing happens.

How do I make this happen?

Thanks!