Solved How to use fill-in colors in Excel?

Dell - inspiron 17.3" laptop - 4gb memor...
July 19, 2014 at 09:16:27
Specs: Windows 8.1, AMD A8/4.0Gb
I have a long list of numbers that are not arranged in order. I need to highlight (in yellow) any number that is greater than 4. I have tried to use different functions but have been unable to do so.

Thank you.
Brian W

See More: How to use fill-in colors in Excel?

Report •

July 19, 2014 at 10:54:27
✔ Best Answer
Your looking for Conditional Formatting:

Select your range of cells
On the Ribbon/Task Bar
Select Home
Select Conditional Formatting
Select Highlight Cell Rules
Select Greater Than
Enter the Number 4
Click OK

See how that works for you.


Report •

July 19, 2014 at 12:23:54

Thank you for your assistance; it worked exactly as I had needed.

Brian W

Report •

Related Solutions

Ask Question