• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
How2forU

How2forU

easy answers for you and me

  • Laptop & PC
  • Smartphone & Tablet
  • Office
  • Apps & Software
  • Glossary
  • Blog
  • Hobby
Home » Excel: How to change the background color based on the cell value

Excel: How to change the background color based on the cell value

11/30/2020 by Sarah Winter

Especially for huge MS Excel tables, it is helpful to mark cells with colors, if they contain a certain value. This is possible by using the “If-function”. In this article we will show you how.

Changing the background color of Excel cells using the “If – function”

Time needed: 3 minutes.

The easiest way to explain how changing the colour of Excel cells via the if-function works is by using an example. So, let’s imagine you’re recording accounting transactions. To immediately spot negative values, you can highlight these cells using the if-function.

  1. Prepare a list

    As a starting point, prepare a list of all your accounting transactions. Mark the cells you want to highlight with colors according to their value.Screenshot of the first step of how to change the background color based on the cell value

  2. Choose “Conditional formatting”

    click on the tab named “Home” and find the button “Conditional formatting”.Screenshot of the second step of how to change the background color based on the cell value

  3. Select your formatting features

    This function allows you to change colors of cells based on their value: You can choose between “Less than…”, “Greater than…”, “Between…” and many more options. For our example, we want to mark cells with a value less than zero with a red background color. Therefore, click on “Highlight cell rules” and “Less than”.Screenshot of the third step of how to change the background color based on the cell value

  4. Enter formatting conditions

    Chose “0” in the field “Format cells that are less than” and decide for a formatting option. For our example “Light red fill with dark red text” is most appropriate.Microsoft Excel Format cells that are LESS THAN

  5. Confirm your selection

    Click on “OK”. MS Excel will format the cells you marked in the beginning immediately.Screenshot of the fifth step of how to change the background color based on the cell value

  6. Check the result

    Now you are able to see days with negative revenues quickly. You can repeat this procedure for other formatting options. For example, use the button “Between than” to highlight days with earnings high enough to meet your long-term business goals.Screenshot of the sixth step of how to change the background color based on the cell value

💡 Related Posts:

  • How to change app icons on your Smartphone
    How to change app icons on your Smartphone
  • Instagram: How to change your username
    Instagram: How to change your username
  • Netflix: How to change the language
    Netflix: How to change the language
  • Windows 10: How to change your computer name
    Windows 10: How to change your computer name
  • How to change line spacing in Word
    How to change line spacing in Word
  • How to change app icons on your iPhone
    How to change app icons on your iPhone
  • How to use superscript and subscript in Excel
    How to use superscript and subscript in Excel
  • How to find and replace: A Guide for Word, Excel and Google Docs
    How to find and replace: A Guide for Word, Excel and Google…

Filed Under: Office Tagged With: documents, Excel, Microsoft Office

Tags

Alexa Android app app icon Apple Covid-19 definition DIY documents e-mail Excel Facebook Gaming Gmail Google Halloween health Holidays Instagram iOS iPad iPhone Mac messages messenger Microsoft Office monitor music Netflix network Outlook Samsung screenshot shortcuts Signal Smart Home smartphone social media Telegram video call WhatsApp WiFi Windows10 Word Zoom

Primary Sidebar

Browse our How Tos

Browse by category

  • Glossary
  • Smartphone & Tablet
  • Laptop & PC
  • Hobby
  • Office
  • Apps & Software
Teaser image for the article "USB: Difference between charging and data cable"

USB: This is the difference between charging and data cable

05/12/2021 By Jennifer Fritsch

The difference between a USB data cable and a USB charging cable is not obvious to everyone at first glance. We explain the differences between the two and how to tell them apart.

How to Delete Contacts on iPhone

01/31/2023 By Nadine Noppinger

Keeping your iPhone’s contacts organized can be a challenge, especially as you add more and more contacts over time. If you have duplicate contacts or outdated information, you may want to delete some of your contacts. This article will show you how to delete contacts on your iPhone. How to Delete a Single Contact on […]

mac

How to take a screenshot on your MacBook

04/08/2021 By How2forU

If you’d like to take a screenshot you’ll just need to know simple key combinations. We’ll show you how to take a screenshot.

How to play Skip-Bo

How to play Skip-Bo: Short description of rules

02/02/2022 By Nadine Noppinger

Skip-Bo is a card game for 2-6 people with set rules. The player who gets rid of all the cards the fastest wins. How to prepare and play the game and what the rules are, you can read in this practice tip. Rules of Skip-Bo Skip-Bo has many decks of cards, which makes the game […]

How to Delete a Page in Word

01/31/2023 By Nadine Noppinger

Are you struggling with an extra page in your Word document that you can’t seem to get rid of? Fear not, deleting a page in Word is actually quite simple. Here’s a step-by-step guide on how to delete a page in Word. Step-by-Step Guide And that’s it! Now you know how to easily delete a […]

How to delete a discord server

How to Delete a Discord Server

02/01/2023 By Nadine Noppinger

Discord is a popular chat platform used by millions of people around the world. If you no longer need a server, you can easily delete it by following the steps below.

Categories

  • 💡 Laptop & PC
  • 💡 Smartphone & Tablet
  • 💡 Office
  • 💡 Apps & Software
  • 💡 Glossary
  • 💡 Hobby

Smartphone & Tablet

How to change app icons on Android & iOS14💡 iPhone: How to recover deleted text messages💡How to share your iPhone calendar💡Sidecar: How to turn an iPad into a secondary Mac display 💡Huawei: How to take a Screenshot 💡 Samsung Galaxy S8: How to take a screenshot 💡 How to find your IMEI number 💡 iPad: How to take a screenshot

Laptop & PC

How to check your CPU temperature 💡 Is there a snipping tool for Mac? 💡 How to take a screenshot on your MacBook 💡 How to connect laptop to monitor

Office

How to fix slow running Windows 10 💡 How to use emojis in Microsoft Outlook 💡 How to password protect a folder in Windows 10 💡Excel: How to change the background color based on the cell value 💡 How to disable startup programs in Windows 10 💡 Word: How to start page numbering on page 3 💡 How to take screenshots on Windows 10

Apps & Software

How to start a video call on viber 💡 Funny questions you can ask Alexa💡Alexa glows green 💡 How to recover deleted WhatsApp messages 💡 Alexa glows yellow 💡 How to delete your Snapchat account 💡 How to merge several PDF files 💡 How to edit PDF files 💡 How to create a Gmail account 💡 Spotify Family: How to share an account 💡 Spotify costs: Free Account vs. Premium

Hobby

How to make homemade hand sanitizer 💡 What to eat after a colonoscopy 💡 How to keep chickens 

Glossary

What is 5G? 💡 What is 4G and 4G+? 💡 What’s Bixby? 💡 What is a VPN connection? 💡 What is the WPS button and where can I find it? 💡 “Thug life”: What does that mean? 💡What is a hashtag? 💡 What is SSID?

Footer

Pages

  • Blog
  • How2forU
  • Imprint
  • Privacy Policy

Copyright © 2023 · Genesis Sample on Genesis Framework · WordPress · Log in