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.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,053
Office Version
  1. 365
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
8,053
Office Version
  1. 365
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
8,053
Office Version
  1. 365
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,127
Messages
5,857,528
Members
431,883
Latest member
Hien

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top