How to Change Cell Color Based on Value Microsoft Excel
- George Apostolov
How to Change Cell Color Based on Value Microsoft Excel: step-by-step guide
Select your data by clicking the first cell, then press Ctrl + Shift + Right Arrow and Ctrl + Shift + Down Arrow.
Go to the Home tab, click on Conditional Formatting, and select Manage Rules.
Click New Rule, then click OK.
Choose Format only cells that contain.
Set the rule to format cells with values greater than or equal to your sales target (e.g., 5000).
Click the Format button, go to the Fill tab, and choose a color for the background (e.g., green).
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.
Quick answer: To change cell color based on value in Microsoft Excel, select your data, open Conditional Formatting from the Home tab, and create a new rule. Choose to format only cells containing your target value, select a background color under the Fill tab, and apply the settings to highlight matching cells.
About this Microsoft tutorial
Highlight data automatically in Microsoft Excel by setting conditional formatting rules based on specific cell values. This guide shows how to change Cell Color Based on Value Microsoft Excel in 7 steps, starting with "Select your data by clicking the first cell, then press Ctrl + Shift + Right Arrow and..." and finishing with "Click Apply and OK to highlight cells above the target in green. Changing the sales tar...". The interactive demo above is a click-through copy of the real Microsoft interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to change Cell Color Based on Value Microsoft Excel?
7 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Microsoft data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Microsoft and Excel. Related guides: How to Change Currency in Microsoft Excel, How to Change Data Type in Microsoft Access and How to Change Date Format in Microsoft Excel. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
