Conditional formatting for progressive values

[dlvgolf]

I'd like to conditonally format a cell green if the value is:
G1, G2, G3, etc

and
I'd like to conditionally format the same cell blue if the value is:
B1, B2, B3, etc.

Thanks for your help.

 

[Oaktree]

Select A1 or whatever cell

Format --> conditional formatting

Condition 1: Formula is: =ISNUMBER(MATCH(A1,G1:G100,0)) apply green format

Similar approach for blue in condition 2

 

[dlvgolf]

Thanks for your feedback.
Just so I'm clear, there is no change in the formula for the blue pattern, just the change in the pattern?

 

[Oaktree]

Right. You're matching the second criterion against a different list, so it would just be
=ISNUMBER(MATCH(A1,B1:B100,0))

 

[dlvgolf]

I must be doing something wrong.
I'm in cell AI5 and have the following conditional formatting set:

Condition 1

Formula is =ISNUMBER(MATCH(AI5,G1:G100,0))
(formatted to green)

Condition 2

=ISNUMBER(MATCH(AI5,G1:G100,0))
(formatted to blue)

Cell value is B2

No formatting showing up.

More help would be appreciated. Thanks.

 

[Oaktree]

Per my previous post, your condition 2 shouldn't have G's in the range, it should have B's.

I think we had a failure to communicate. By *pattern*, I thought you meant in the formula. I think you meant in the color scheme. Either way, that change should fix it.

 

[dlvgolf]

My apologies... that was a typo, the 2nd condition is set to B

I've tried changing the cell value From B1 to C1 and no change.