Book1.xlsxGuys i need help, Please very urgent if some body could HELP make a macro ...would reallly appriciate it ..thx

What i want is in the amount field there are amounts ...idf there a 100 dr and 100 credit should get highlighted ....attaching a file for ur reffrence ...
Please Need this