If-Then rules allow you to create colorful business spreadsheets that do more than look pretty. Meaningful colors can help you and others identify data quickly, recognize trends and even spot ...

In this post, we will show you how to count colored cells in Microsoft Excel. While working with Excel, we often color-code cells to distinguish them from the rest of the data. This is good because ...

How to count individual cells within a row by their fill color in Excel Your email has been sent The article How to easily sum values by a cell’s background color in Excel shows you an easy way to ...

Let’s say you have a student gradebook file open in Excel and it contains information for the students in your class. As you look through the students’ grades, you highlight the names of students to ...

In this post, we will show you how to change the Gridline color in Excel. Gridlines are the lightly visible lines that appear around cells in a worksheet to differentiate them and make the data easier ...

Alternating row or column colors assists data identification by making the row or column easier to distinguish. In Microsoft Excel, you can achieve this effect using conditional formatting to change ...

How to add color to a drop-down list in Excel Your email has been sent Color can be a powerful element in an Excel drop-down list, and it’s easier to add than you might think. Perhaps you want to use ...

Every time Laura publishes a story, you’ll get an alert straight to your inbox! Enter your email By clicking “Sign up”, you agree to receive emails from ...

You can use Microsoft Excel in dark mode to change elements of your spreadsheet to a darkened color palette. You control the dark mode in the Account settings from the ribbon's File menu. To make the ...