Excel Conditional Formatting using Index Match and Wildcards
I have a spreadsheet that reviews payment file names and values that needs formatting to highlight specific lines where the file exceeds a set value based of the file name & its storage location, as there can be some cross over amongst the names and drop locations.