conditional format/compare
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
|