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, such as the following monthly temperature data with cell colors tied to cell 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.
To learn more about how to use Conditional Formatting, click this link to visit the Microsoft support article: Use conditional formatting to highlight information - Microsoft Support.