How to highlight data in Excel based on the number you input into a cell and the comparison you want to make.
This allows you to quickly input a new number and comparison in cells in Excel and then highlight the data that meets that criteria.
This trick combines:
This is an easy trick to add to any workbook in Excel and I show you how to customize it for your needs.
Apply Conditional Formatting to Multiple Cells with a Single Formula