Bernard, thank you. That does work fine for the whole sheet. What if
the ranges are comparing values in Col:A versus the corresponding
value in col: V? (Lets just say A5: vs. V5.) Again, ignoring the
rule if either contains a blank?

Thanks so much.

Pierre

On Jan 12, 1:53*pm, "Bernard Liengme"
wrote:
Select A1:B1
Home tab/conditional formatting / highlight rules /duplicates
works a treat
best wishes
--
Bernard Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme

"Pierre" wrote in message

...



I've always thought CF was one of the more understandable tools used
in Excel. Until now. Using Excel 2007.
Trying to hilight a cell if it's contents are the same as another cell
(Lets say A1 same as B1.). *Also want to ignore the CF rule if either
cell is blank.
It's driving me bonkers. *Ideas?
TIA.
Pierre- Hide quoted text -

- Show quoted text -