Use Conditional Formatting to Highlight Data in Excel | Powerful Feature in Excel
Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values |
You can apply conditional formatting to a range of cells (either a selection or a named range), an Excel table, and in Excel for Windows, even a PivotTable report.
Conditional formatting in Excel is a powerful feature that allows you to automatically highlight cells based on specific conditions.