Urgent, VBA conditional Formatting (Paring Value)

Hi All, Please help,

let say this is the table: Already match the positive and negative value

ID____Number: Value____Code____Company Name_____Date
1____(-1409810.28)____VJ______Company 1_____Day 2
2____1409810.28 ______VJ______Company 1_____Day 2
3____469747.8 ______RN______Company 1_____Day 2
4____(-469747.8) ______RN______Company 2_____Day 2
5____(-78291.3) ______RN______Company 3_____Day 5
6____78291.3_________RN_______Company 3_____Day 5
7____(-38915.52)______VJ______Company 8_____Day 3
8____38915.52________VJ______Company 8________Day 3
9____(-14102.48)______SY______Company 1______Day 3
10____14102.48_______SY______Company 2_______Day 2

As you can see ID 1 and 2 have the same Number value = to zero. Highlight row to green when Company Name and date is the same "example ID 1 Company is the same to ID 2 company, Also in date
and ID 3 and 4 highlight row into yellow when their company name and date is different to each other.
and as you see in ID 9 and 10 has Code is SY highlight it into blue when it is SY, and the Number value is = to zero

Here's my formula getting positive and negative paring,
=IF(A4="","",IF(A4<0,-A4&"_"&COUNTIF(A$2:A4,A4),A4&"_"&COUNTIF(A$2:A4,A4)))

=IF(COUNTIF(B:B,B4)=2,"x","")
I filter it "X" to get all pair

Hope you help us. Many thanks in advance

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.