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 -

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

Thanks for all.

Pierre
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top