Hi all,

Please help code to meet conditional formatting for this table below.

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