highlighting with conditional formatting

Microsoft Microsoft excel 2007 (pc)
March 8, 2010 at 13:03:52
Specs: Windows XP
I have two columns of numbers. One column has 60 rows and the other has 500. All 60 of the values in column 1 can be found in column 2. I would like a formula for conditional formatting that will find those 60 values from column A in column B to highlight them in red to visually separate them from all the others values. Does such a formula exist?

See More: highlighting with conditional formatting

Report •

March 8, 2010 at 13:09:59
Assuming your column of 60 is in A1:A60 and your column of 500 starts in B1, try this:

Select B1:B500.

Use this formula:


(I don't have 2007, so I can't give you the step-by-steps, just the formula to use.)

Report •

March 8, 2010 at 13:24:01
Here's a step by step:

1) Select your cell B1:B500.

2) On the ribbon click Conditional Formatting

3) Click on New Rules, it’s near the bottom of the dialog box.

4) Click Use Formula to determine which cells to format.

5) Enter DerbyDads formula: =MATCH(B1,$A$1:$A$60,0)

6) Click on the Format button

7) Select the Fill Tab

8) Select a pretty color

9) Click OK

10) Click OK



Report •

March 8, 2010 at 14:11:12
That worked! Thank you so much for helping me save hours of my time!

Report •

Related Solutions

Ask Question