Excel 2007 CF Multiple criteria
 

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

Excel 2007 CF Multiple criteria
 

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

Excel 2007 CF Multiple criteria
 

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 -

Excel 2007 CF Multiple criteria
 

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