Excel 2007 CF Multiple criteria

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
 
B

Bernard Liengme

Select A1:B1
Home tab/conditional formatting / highlight rules /duplicates
works a treat
best wishes
 
P

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
 
P

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
 
Top