Conditional formatting on ADJACENT Cells

[jayceejay]

I know this may sound like a dumb question, but I have values in column A
that I want to have a grey background if their corresponding value in Column
B =1. I can't seem to find a way to establish that condition for a cell
other than itself! HELP, Please??

 

[Per Jessen]

Hi

No dumb questions here.

Select A1 and goto Conditional Formatting > Condition1 : Formula is >
Formula to be entered in the next field: =B1=1
Format as desired.

Regards,
Per

 

[Gary''s Student]

click on A1 and Format > Conditional Formatting > Formula is>

=B1=1

and pick a grey background

 

[jayceejay]

So do I have to Format each cell individually? Cuz I can't get it to work
for a range.