Excel 2007 : Conditional Formatting

[IL_Lee]

A B D
AB 001 AB001
AC 001 AC001
AD 007 AD007
AE 008 AE008
AT 009 AT009
AB 010 AB010
AC 011 AC011


Hello,

I am hoping this is one of those questions that, once answered, causes the asker to kick his own ***.
I am using conditional formatting to highlight a single cell in a column with the condition based on another cell.

I have three columns. A is a type. B is a number associated with the type. As you can see from the example, each type and number may be repeated within its column. To create a unique identifier, I used concatenate to unite A and B in column D.

Column D serves as the condition, where if one of those identifiers is repeated, then the number in column B associated with it is highlighted. I used =Countif(D:D,D1)>1 in the conditional formula. This works fine for one cell.

How do I make this work for the entire column? Please let me know if clarification is needed.
Any help with be appreciated.

(Also, my column headers are not lining up for the post. It's that kind of night.)

[SCLai]

For your conditional formatting, try..
1.) Highlight the whole Column (Col D)
2.) Use your formula & formatting for conditional formatting

So I think the only difference is that you have to 1st highlight the column for it to be applied to the whole column.

Alternatively, you can also copy D2, which already has that conditional formatting, then select the whole column D
Right Click > Paste Special > Formats.

Hope this is what you are looking for!

SC

[IL_Lee]

Thank you. I feel like a complete ***.