Comparing the Column and highlighting the Same number

[Rafay Ahmed]

Hi All,
Attached is the file, I have to compare two columns and highlight both the columns.
Further guidelines are in the Sheet.
Thanks

 

[Hui]

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



set a Format with the Format Button

Ok


Enjoy

 

[NARAYANK991]

Hi ,

The approach suggested by Hui may not work where the match is in different rows.

Narayan

 

[Rafay Ahmed]

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?

 

[bosco_yip]

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?

Duplicated question and attachment

https://chandoo.org/forum/threads/have-to-compare-two-columns-and-highlight-both-the-columns.37746/

Regards
Bosco

 

[Rafay Ahmed]

I am new to chandoo, I thought to post it to both Macro and Excel question forum.

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[Rafay Ahmed]

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,

 

[NARAYANK991]

Hi ,

See this revised file.

Narayan

 

[Hui]

Your original data file only highlighted the Matching 100's

It didn't highlight the other data shown below, which yes does match