Highlight values in one column based on values in another.

[EtherBoo]

Hello everyone,
This should be pretty easy but I can't seem to figure it out for the life of me.

Basically, I have 2 columns; D and AB.

Without getting too wordy, if on the same row a value exists in AB, then I need the corresponding value in D (the value within the same row) to be highlighted.

Is this possibly with conditional formatting or will I need to write / have someone write a macro that can do this?

Thank you.

 

[edokhotnik]

Highlight the data in column D (D1 being the active celll) and format with this formula =$D1=$AB1 . HTH, Ed

 

[EtherBoo]

Is there anyway to make it so that the value does not have to match identically? As in, if there is a value, then highlight?

I made some modifications and it worked like a charm. Thank you.