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

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

John

Select B1:I1
Click Format Conditional Formating
under Condition 1's dropdown, Choose Cell Value Is
select greater than or equal to in the next dropdown
place =$A1 in the range box
Go to Format Patterns Select green
OK out

On the worksheet,
Select B1:I1
copy down as using the mouse

This will format all the cell under with your conditions

HTH
--
If this posting was helpful, please click on the Yes button

Thank You

cheers,









"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