Solved Excel 2010, using conditional formatting on columns of data.

November 28, 2012 at 08:08:14
Specs: Windows 7
I have 10 columns of numbers, at the top of each column I put in a master key. I want to hi-light any cell in the 10 columns that contains one of the values in the master key. Example: my master key row is 2. So in D2, I have the value 22. In I8, L95, C5 I have the value 22. I need to have them hi-light when I enter 22 in D2.

See More: Excel 2010, using conditional formatting on columns of data.

Report •


#1
November 28, 2012 at 08:20:20
✔ Best Answer
Try this:

With your key in cell D2
and your Range of Data is the array of cells C5 thru L95

Conditional Formatting 2007

1) Select your cell or range of cells, IE C5:L95
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 the formula:

=C5=$D$2

6) Click on the Format button
7) Select the Fill Tab
8) Select a pretty color
9) Click OK
10) Click OK

See how that works.

MIKE

http://www.skeptic.com/


Report •

#2
November 28, 2012 at 08:32:19
Thank you Mike.
I just repeat that for each master key cell in the master key row?

Report •

#3
November 28, 2012 at 08:46:56
I just repeat that for each master key cell in the master key row?

Yes, you will need 10 Rules:

=C5=$D$2
=C5=$E$2
=C5=$F$2
=C5=$G$2
etc. etc.

Also, if you want to add a bit of flair,
for each Rule show a different color.

So:

$D$2 = 22 = Red
$E$2 = 55 = Orange
$F$2 = 99 = Yellow

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
November 28, 2012 at 08:52:09
Thank you very much, solved.

Report •


Ask Question