How to Change Cell Color Based on Value Microsoft Excel

‍

‍

Here's how to do it:

‍

1. Select your data by clicking the first cell, then press Ctrl + Shift + Right Arrow and Ctrl + Shift + Down Arrow.
2. Go to the Home tab, click on Conditional Formatting, and select Manage Rules.
3. Click New Rule, then click OK.
4. Choose Format only cells that contain.
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 color for the background (e.g., green).
7. Click Apply and OK to highlight cells above the target in green. Changing the sales target (e.g., to 7500) will automatically update the formatting.