Match (conditional formula)

[bhasoriya]

I have many cells, which I want to math..


If J13 can not match with J15 then J13 cell should be highlight.


How I made formula for this.. Thanks.


For further details please check uploaded file on below given link

https://rapidshare.com/files/3070322090/Example.xlsx

 

[sreekhosh]

Hi bhasoriya,


I think you can do the conditional formatting with unique values.


conditional formatting->Highlight Cells Rules->Duplicate Values


after that select "Unique" From the Drop down instead of Duplicate.


Thanks

Sreekhosh

 

[nazmul_muneer]

Dear bhasoriya

I think you tried the solution that i provided as you required.


For your today's problem,

Col-A Col-B

1586 1280

1587 1256

1588 1085

1589 1589

1590 1171

1591 1968

1592 1826


Select Column A

1. Conditional Formatting

2. Manage Rules

3. New Rule

4. Format only cells that contain

5. Set criteria from "Edit the rule description"

Cell Value not equal to =B2

6. Format as you want

7. Ok/Apply

Done!

 

[bhasoriya]

Thanks nazmul_muneer. It is working.. thanks a lot...