The Power of SQL in Microsoft Excel
Add-In the power of SQL to Microsoft Excel®
Coloring Rows that Match Your Criteria
(Click Images to Enlarge)
Using QueryCell it is very easy to color rows that match your criteria even if your criteria involves joining to other regions of data. Simply check the 'Mark Results' checkbox, Select the color you wish to use and run a SQL statement selecting * from the table you wish to mark and using a WHERE clause to specify your criteria.