Conditional formatting on ADJACENT Cells

J

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??
 
P

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
 
G

Gary''s Student

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

=B1=1

and pick a grey background
 
J

jayceejay

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

David Biddulph

Either use format painter to copy your format down the range, or select the
range before you apply the CF condition. Make sure that your CF condition
is exactly as suggested, and that you don't, for example, have an absolute
address where you want a relative address.
 
Top