One way:

Select column B:I (or select B1:Ixxxx), with B1 the active cell.

Choose Format/Conditional Formatting:

CF1: Formula is =B1<=$A1
Format1: <patterns/<green

XL will make the appropriate adjustments for the other cells.


In article ,
John wrote:

I am working with a large spreadsheet used for an inventory for several
locations. Each item has an inventoried amount, ex
A B C D E F G
H I
Item Req loc1 loc2 loc3 4 5 6
7
Analyzer, Cli 7 0 6 7 5 7
6 0

I figured out how to change the cell color to green if the count is greater
than or equal to the count in colum B for the 7 locations. The problem is
that I have to do this for several thousand rows and I'm doing this one row
at a time. Is there a way to format all the rows at once? the conditional
format states for each row say b1:i1 the cell is green if it is greater than
or equal to a1. then the next row b2:i2 = a2?

Thanks