conditional formatting

  • Thread starter Thread starter mp
  • Start date Start date
M

mp

I have about a 1000 sets of 2 cells each with numbers:

A B

1 100 104

2 102 102

3 106 105

I would like to highlight the sets of cells that in which
the numbers match automatically (A2 and B2 here). I
figured you could conditionally format to do this, but
have been unable to figure it out...if it is possible?

Thanks again

mp
 
Hi
try the following
- select your cells in column A and B
- goto 'Format - Conditional format' and enter the formula:
=$A1=$B1
- choose your format
 
Highlight Column B

format / conditional format, cell value is "equal to" a1,
then select the format button, choose your formating
change.


Would a formula in column c work better for you?

If(B1=A1,"1"," ") (if you want you can replace the
information within the "" to whatever you want

Then at the bottom you can add up (our count) column c to
determine how many matched.
 
Back
Top