Hi all, I am trying to match by amount with 1 column to another in a different sheet
If Data in column A in worksheet 1 matches data in column b worksheet 2 then color the entire row in column A worksheet 1 red , I am matching by amount so it(amount in column a) can be within 1 $ of amount in column b worksheet 2 also color item in column b(worsksheet2) red if matches with column a in worksheet 1 both can have a threshold of 1$ difference
would be much appreciated if someone could help
Thx in advance