• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Comparing the Column and highlighting the Same number

Hui

Excel Ninja
Staff member
Select B2:C481
goto the Home, Conditional Formatting, New Rule tab
Format values where: =$B2=$C2

upload_2018-3-14_8-48-30.png

set a Format with the Format Button

Ok

upload_2018-3-14_8-49-21.png
Enjoy
 

Rafay Ahmed

New Member
Thank Hui. Narayan is right its not working when the match is in different rows. Also, I have different set of data, in the attachment. can you help me in this case also?
 

Attachments

Rafay Ahmed

New Member
I dont think so, as sum of the highlighted amounts in debit and credit should be equal. See 86.49 is twice in Credits and once in Debits, 86.49 should get highlighted once in each debit and credit leaving one unhighlighted in credits,
 

Hui

Excel Ninja
Staff member
Your original data file only highlighted the Matching 100's

It didn't highlight the other data shown below, which yes does match
upload_2018-3-14_16-26-12.png
 
Top