Conditional formatting for progressive values

dlvgolf

New Member
Joined
Dec 16, 2004
Messages
19
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.
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,986
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

New Member
Joined
Dec 16, 2004
Messages
19
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

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,986
Right. You're matching the second criterion against a different list, so it would just be
=ISNUMBER(MATCH(A1,B1:B100,0))
 

dlvgolf

New Member
Joined
Dec 16, 2004
Messages
19

ADVERTISEMENT

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

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,986
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

New Member
Joined
Dec 16, 2004
Messages
19
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,674
Messages
5,549,358
Members
410,910
Latest member
DessertDiva
Top