Hi,

1. Using conditonal formatting means that you can look for visual effects
such as cell color, which are often easier to spot in large data sets than
cell which might say Match or No Match, for example.
2. Using condtional formatting means that you do not have to dedicate a
column of cells to holding a formula. Therefore you are conserving
spreadsheet space and reducing clutter.
3. Using the formula in the cell has the advantage that other cells can use
that result to make additional calculations, whereas formulas can't detect
condtional formatting.

I like the conditional formatting approach, except when you are using 2003
and earlier and want more than 3 conditions, which is not the case here.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"< AVG Joe" wrote:

Thanks!
Still unable to decide which way to go...

"Rick Rothstein" wrote:

I think you are looking for this...

=IF(B1,IF(D1=D2,"Match",""),"")

Put it in C1 and copy down.

--
Rick (MVP - Excel)


"< AVG Joe" wrote in message
...
Perplexed-
How do I check a condtion say If(Bw=TRUE),
Then compare cells D2 & D3 for equality)
and repeat for about 1000 rows?
Example:
A B C
D E
1 N TRUE If (B1=True, If(D2=D3), "MATCH") Q
2 N FALSE If (B2=True, If(D2=D3),"") Q
3 Y TRUE If (B3=True, If(D3=D4), "MATCH") Y
4 Y FALSE If (B4=True, If(D4=D5), "") Y