Hi there, I'm looking for a way to conditionally format a MASTER type worksheet with a weekly update, based on exact match of a couple columns to check to see if a 3rd and/or 4th column have changed from one week to the next. In a nutshell
Column A: Invoice Number (Needs to match)
Column B: Invoice Date (Needs to match)
Column C: Invoice Outstanding Amount (Can vary)
Column D: Invoice Paid off Date (Can vary, from being blank, to having a date)
So, Invoice # and Date need to match, then compare to see if Outstanding amount is different, and/or paid off date is different.
What's the best way to go about doing this compare? I've tried a Ablebits and such, but they don't seem to do quite as much comparing as I'd like to be, unless I'm just not using it quite right.
Thanks!
Column A: Invoice Number (Needs to match)
Column B: Invoice Date (Needs to match)
Column C: Invoice Outstanding Amount (Can vary)
Column D: Invoice Paid off Date (Can vary, from being blank, to having a date)
So, Invoice # and Date need to match, then compare to see if Outstanding amount is different, and/or paid off date is different.
What's the best way to go about doing this compare? I've tried a Ablebits and such, but they don't seem to do quite as much comparing as I'd like to be, unless I'm just not using it quite right.
Thanks!
