conditional format/compare

G

Guest

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
 
R

Rick Rothstein

I think you are looking for this...

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

Put it in C1 and copy down.
 
L

Luke M

Assuming you're putting this in conditional format, where you want the effect
applied if TRUE and a match:
=IF(B1=TRUE,IF(D2=D3,TRUE,FALSE),FALSE)

Then copy and paste special the formating.
If your using a cell and literally want the word "match" jsut change to:
=IF(B1=TRUE,IF(D2=D3,"MATCH",""),"")
 
S

Shane Devenshire

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.
 

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