On Jan 12, 2:22*pm, Pierre wrote:
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 -- Hide quoted text -

- Show quoted text -

I figured it out.
Formula is: =AND($E20,$E2=$J2) in this instance. Format as desired.

Thanks for all.

Pierre