Forum Discussion
Excel - VBA Help - Two Sheets matching amounts
I have two sheets that I need to compare from each other. On sheet 1, in column CR, I have a column of amounts, that I need to verify if all are listed, compare to Sheet 2, columns, S-AC. there are ...
See the attached version. You'll see that the entire column B is highlighted. This is because the values in column B are text instead of numbers.
And most of column M is highlighted. This is because the category Ttl_Fee does not occur on Sheet1.
I understand on the Ttl_Fee. My question is how did you figure it? Formula?VBA? Conditional Formating? I have to do this every month.
It's conditional formatting of type 'Use a formula to determine which cells to format'.
Select A2 on the second sheet, then click Conditional Formatting > Manage Rules... > Edit Rule to see the formula that I used.