Conditional formatting

Ineedhelpaz

New Member
Joined
Sep 23, 2014
Messages
3
Excel 2007 question

I am attempting to highlight several thousand values in column B based on values in column A. An example...

A. B.

1. 1.
2. 1.
3. 2.
5. 4.
10. 9.


If 1, 2, 3, 5, 10 occur in column B at all I need all instances of them highlighted. Using duplicate values does not work since duplicate values in B that don't exist in A are highlighted.
 
Last edited:

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

skywriter

Well-known Member
Joined
Feb 15, 2014
Messages
1,642
In the example below. I select cells B1:B5, I go to conditional formatting and I new rule, use a formula to decide which cells to format. I then enter the formula: =COUNTIF($A$1:$A$5,B1), then choose a yellow fill if my equation evaluates to true. You get the results shown below.

Excel Workbook
AB
110
225
334
4510
5108
Sheet35
#VALUE!
 
Last edited:

Ineedhelpaz

New Member
Joined
Sep 23, 2014
Messages
3
I filled out formula exactly as you did and it worked but it is not working consistently. Some groups of numbers are labelled in all instances, some aren't labelled at all and some are even half and half (one filled one empty)
 

Ineedhelpaz

New Member
Joined
Sep 23, 2014
Messages
3
Nevermind. I wiped the first one, retyped, and chose a different color and the error stopped.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,624
Messages
5,523,967
Members
409,547
Latest member
AW2020

This Week's Hot Topics

Top