The ability to search by Format instead of Value can be a really useful feature that many of the Excel users have requested Today I...

Request was received to highlight rows dependent on values in specific columns of data. A macro was developed to run through the worksheet and set a value and format for the rows based on the compared columns of information.