How to Change Cell Color Based on Value Microsoft Excel

Quick summary

This tutorial shows how to use Conditional Formatting in Microsoft Excel to automatically change cell background color based on a numeric value threshold. Once configured, updating your sales target instantly refreshes the color-coded formatting across your entire data range.

Steps

1. Select your data range by clicking the first cell, then press Ctrl + Shift + Right Arrow and Ctrl + Shift + Down Arrow to extend the selection.
2. Go to the Home tab, click Conditional Formatting, and select Manage Rules.
3. Click New Rule, then click OK to proceed.
4. Choose Format only cells that contain as the rule type.
5. Set the rule to format cells with values greater than or equal to your sales target (e.g., 5000).
6. Click the Format button, go to the Fill tab, and choose a background color (e.g., green).
7. Click Apply and OK to activate the rule — cells meeting the target highlight automatically, and changing the sales target (e.g., to 7500) instantly updates the formatting.