• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar

Mechanicaleng blog

siemens nx tutorial & injection molding technology

  • Plastic molding
  • Siemens nx
    • nx modeling
    • nx drafting
    • nx sketching
    • nx assembly
  • Mechanical basic
    • mechanical standard
    • Mechanism video
  • microsoft office
    • microsoft word
    • powerpoint
    • excel tips
  • About me
  • CONTACT ME
Home » microsoft office » excel tips » change cell background color in excel by equal formulas

change cell background color in excel by equal formulas

February 25, 2021 by mechanicaleng blog Leave a Comment

In this article, I will show you how to change cell background color automatically in excel with Conditional Formatting tool.

Conditional formatting: Easily spot trends and patterns in your data using bars, color, and icons to visually highlight important values.

When working in Excel, have you ever faced with complicated and sometimes repeated data? A few redundant data will affect the entire calculation result so you need to find and remove them.

How to change cell background color automatically in excel by equal formulas?

Step 1: Click on the value box you need to color, press Ctrl + A if you want to select all the data => then click on Conditional Formatting => select New Rules.
excel-conditional formatting-new rules
Step 2: In the  new formatting rule dialog box,  in the select a rule type, select Format only cells that contain to format the cell according to its value. Select cell value and equal at format only cells with. 
For example, at step one you choose NG to create the background color, here you enter NG.

excel new formatting rules

Next, click Format => Format Cells dialog box appears, click Tab Fill, and choose the color tone you want to fill in the content box. At this tutorial, I select red color, then click OK.

cell-background color

Step 3: After color formatting NG text is completed, in the dialog box Conditional Formatting Rules Manager, click Apply => and OK to save the result and exit the dialog box.
change cell background color automatically in excel
From now on, when you enter the characters like NG, Excel will automatically color them. The sequence is performed similarly to other data regions.

Conclusion.
Using the Conditional Formatting tool, you can similarly color with many repeatable values to easily distinguish them during your work. Also makes it easier for you to control what you enter and what data is on your Excel spreadsheets. Hopefully with today’s small tips will be helpful to you. Good luck!

Related posts:

How to count blank cells in excelHow to count and color blank cells in excel Create border in excel by border tool2 ways to create border in excel remove background color in word6 ways to remove background color in word change background color in nxHow to change background color in nx

Filed Under: excel tips Tagged With: excel beginner, excel tutorial

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • what is spur gear | introduction
  • Mechanical engineering skills from training process
  • What is Inox | Stainless Steel?
  • How to create thread in nx
  • nx assembly| create a new part from the same part
  • how to calculate sum of squares in Excel
  • How to active GC toolkits in Siemens NX
  • How to create a sphere in nx
  • How to create a cone in nx
  • How to create a cylinder in nx

Copyright © 2023 · Magazine Pro on Genesis Framework · WordPress · Log in