Excel 2007 CF Multiple criteria

  • Thread starter Thread starter Pierre
  • Start date Start date
P

Pierre

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





- Show quoted text -
Click to expand...

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

Thanks for all.

Pierre
 
Back
Top