First, you’ll need to select the range of cells that you want to check for duplicates.This takes time and a lot of trial and error. The point is, you shouldn’t jump straight into color coding without actually thinking about how you’re going to make the entire spreadsheet picture become the best it can be. On the other hand, if you’re creating a spreadsheet for a maths class, wanting your irrational number cells to be colored red is a perfectly imaginable and a viable idea. This is not necessarily a bad idea, but if you also plan to color code it to change shade intensity as the numbers grow, it may end up confusing. During the planning process, whenever you come up with a color-coding idea, ask yourself: “Does this make my life simpler or more complicated?” Technically, you could “tell” Excel to color every cell that contains an irrational number red. Jumping right into color coding is certainly a possibility, but, in truth, conditional formatting takes planning before anything else. Highlight Positive, Neutral, and Negative Values with Icon Sets.

How to change bar color in excel