Select A1:B1
Home tab/conditional formatting / highlight rules /duplicates
works a treat
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://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