• Mobile
  • Social
  • IM
  • Computer
  • Internet
  • Smarthome
  • Travel
  • Mobile
  • Social
  • IM
  • Computer
  • Internet
  • Smarthome
  • Travel
home/knowledge base/Computer/Office/Highlighting empty cells in Excel
Popular search:facebook, android, Excel

Highlighting empty cells in Excel

Napisane przez guru
January 24, 2023

Do you want to automatically highlight empty/blank cells in a spreadsheet with color? There is a quick way to do it. Just use conditional formatting. This will automatically change the color depending on whether or not a value appears in the cell.

  1. Open the spreadsheet on your computer;
  2. Select the range for which you would like to implement the conditional formatting mechanism (we omit row and column headers). You can also use the keyboard shortcut CTRL+SHIFT+Down arrow – a very quick way and useful when working with large amounts of data;
  3. Go to the top navigation bar and then click on the “Main Tools” tab;
  4. In the “Styles” area, click on the “Conditional Formatting” option;
  5. Click on the “Cell highlight rules” category and then select the “More rules” command;
  6. A dialog box will appear. Select the type of rule. You should check “Format only containing cells”;
  7. Select “Blank” from the drop-down list, which is located in the “Format only cells that meet the conditions” area;
  8. Click on the “Format” button and then go to the “Fill” tab and indicate the color to appear in the cells if the cells do not contain any value. Confirm by clicking on the “OK” button;
  9. If you want the color to appear in cells containing values, you follow the same procedure as for blank cells (steps 1-6 and 8) with the difference (step 7) that you select “Non-empty” from the drop-down list that is located in the “Format only cells that meet conditions” area.
Tags:officeExcelmicrosoft

Was it helpful?

2 Yes  No
Related Articles
  • How to use SORT function in Excel
  • How to set-up Chrome as a default browser in Windows 10
  • Windows 10 screen rotation
  • How to make a table of contents in Word?
  • How to take a screenshot
Leave A Comment Cancel reply

  • English
  • Deutsch (German)
  • Français (French)
  • Español (Spanish)
  • Polski (Polish)
  • Українська (Ukrainian)
Popular Articles
  • Facebook lock – how long?
  • How do I mark important places on Google Maps?
  • The cleaning robot gets stuck under the furniture – the solution
  • How to make a table of contents in Word?
  • How to take a screenshot
KB Categories
  • Mobile
  • Social
  • Computer
  • Internet
  • Smarthome
  • Travel
  • IM
  • android
  • Facebook
  • messenger
  • WhatsApp
  • Office
  • Other
  • iOS

Try To Help ME

Welcome to the website that's here to turn you from a tech-turtle to a tech-ninja! We've got all the information and instructions you need to navigate the wild world of new technologies, with a side of humour to make it less overwhelming.

Whether you're struggling with a stubborn smartphone or trying to figure out how to use that fancy new app, we've got your back (and your funny bone). So come on in, and let's get tech-savvy together!

Tags
#techsolutions #mobilesupport #socialmediamanagement #computersupport #technologytips #mobileappdevelopment #socialmediastrategies #computerrepair #techtroubleshooting #mobilenetworksolutions
Social Media
#socialmedia #socialmediamarketing #instagram #facebook #twitter #linkedin #socialmediahacks #socialmediamanagement #socialmediastrategies #socialmediatips
Social
  • Facebook
  • Twitter
  • Privacy Policy
  • Terms of Use
  • © 2020 naszanasze. All Rights Reserved.

Popular search:facebook, android, Excel
  • English
  • Deutsch (German)
  • Français (French)
  • Español (Spanish)
  • Polski (Polish)
  • Українська (Ukrainian)