Conditional Formatting a range Based on Another cell

[ib0nfire]

Hey all,
I am trying to Conditional format based on another cell.
I have researched and everything and cant seem to find the problem.
I would like to conditional format a range of cells based on another range of cells
So if =$B:$B="Cancelled" =$A:$A=Red
If =$B:$B=Hold $A:$A=Yellow

I can get it to work for a single cell
so if =B="cancelled" A=red this works but i would like a range
Any help would be appreciated
Thanks!
(My first post)

 

[jeffreybrown]

Hello & Welcome to the Board,

Highlight your desired range in column A (assumes you start at A1)

Enter these two conditions:

=B1="Cancelled" >> Pick format
=B1="Hold" >> Pick format

 

[ib0nfire]

Hey thanks for your quick reply but that i need for a range of vales.
I have highlighted the range i need formatted, then put a range in the formula and selected the format it does not work for a range. only for a single cell does it work

 

[jeffreybrown]

Let's make sure we have this right. If B1 = "Cancelled", then you want A1 to be colored Red and so on?

 

[ib0nfire]

Yes that is correct. A1:A300 to match to B1:B300

 

[jeffreybrown]

Yes that is correct. A1:A300 to match to B1:B300

Then you Highlight A1:A300 (you must start the highlight from A1 and down)

In conditional formatting you enter these two conditions

=B1="Cancelled" >> Pick format
=B1="Hold" >> Pick format

 

[ib0nfire]

Yes but that will only match to B1 i need A1 to reference B1, A2 to reference B2 and so on.
I have highlighted what i need formatted say
A1:A20 then in formula put in
=$B$1:$B$20="CANCELLED" ...Pick format

But it only matches to B1.
I need them to match to the adjacent cell all the time .

 

[jeffreybrown]

Yes but that will only match to B1 i need A1 to reference B1, A2 to reference B2 and so on.
I have highlighted what i need formatted say
A1:A20 then in formula put in
=$B$1:$B$20="CANCELLED" ...Pick format

But it only matches to B1.
I need them to match to the adjacent cell all the time .

Then maybe follow the previous post

Then you Highlight A1:A300 (you must start the highlight from A1 and down)

In conditional formatting you enter these two conditions

=B1="Cancelled" >> Pick format
=B1="Hold" >> Pick format

Why have you entered =$B$1:$B$20="CANCELLED" ...Pick format when this is not what was offered

 

[ib0nfire]

I have tried =B1"Cancelled" this works.
Now the second condition will not apply.

I tried the range because =B1="Cancelled" was not applying downward to the respective cells. However now it does.

The second condition however is not applying. I am sorry this has been frustrating me at work all day.

 

[ib0nfire]

1