Dear All,
I am looking for excel formula or VBA code which will check different cells and highlight in case of repeat or more than approved value.
Refer below sample
1> Here excel will check GCS code (B4), Name(C4), Claim Type (D4) - with rest of the below cells in case of repeat entry excel should highlight repeat line with red color and put remark in H column.
2> At the same time excel will also check GCS code (B7), Claim Type (D7) and Amount (E7) - if found more than approved amount in table 2 excel should highlight repeat line with orange color and put remark in H column.
Could you please help me in doing this...
I am looking for excel formula or VBA code which will check different cells and highlight in case of repeat or more than approved value.
Refer below sample
1> Here excel will check GCS code (B4), Name(C4), Claim Type (D4) - with rest of the below cells in case of repeat entry excel should highlight repeat line with red color and put remark in H column.
2> At the same time excel will also check GCS code (B7), Claim Type (D7) and Amount (E7) - if found more than approved amount in table 2 excel should highlight repeat line with orange color and put remark in H column.
Could you please help me in doing this...