top of page
  • Writer's pictureImran Din

"To Be Formatted or Not to Be Formatted" - Conditional Formatting in Excel

"Should I be formatted?" thought an Excel cell. “It depends...”

Conditional Formatting is another Powerful feature in Excel. You can set rules for formatting cells based on a Criteria! When the Criteria is True, formatting will be applied to the cell automatically!

For example, let's say you have a list of friends that you have invited to your party, and you want to highlight the ones that have said Yes as green and the No's as Red. This is easy to do using Excel's Conditional Formatting!

First, we'll select our list of names. Then, click on 'Conditional Formatting' from the Home tab in the Ribbon:

In the dropdown, we'll select New Rule...

In the popup, we'll select "Use a Formula to determine which cells to format":

In the formula, we will write a formula for the first cell in our selection. The formula should equal True if we want it to be formatted.

In our case, we want the A1 cell to be formatted if B1 says "Yes".

So, we'll type =B1="Yes" into the formula bar.

Next we'll click on the Format.. button to select what format should be applied:

I'm using the lightest green as my background fill and the darkest green for the font. But you choose whatever you like most! Afterall, you are the Édouard Manet of your Conditional Format!

Now you know who's coming to your party! Hit it!

9 views0 comments


bottom of page