For example, in a green, yellow, and red color scale, you can specify that higher value cells have a green color, middle value cells have a yellow color, and lower value cells have a red color. …

Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You …

Go to Home > Conditional Formatting > New Rule. In the Select a Rule Type box, select Use a formula to determine which cells to format. To apply color to alternate rows, in the Format …

Data bars, color scales, and icon sets are conditional formats that create visual effects in your data. These conditional formats make it easier to compare the values of a range of cells at the …

If you'd like to give your calendar a brighter, more visually dynamic look, you can use conditional formatting to color-code your appointments and meetings based on sender, location, or …

There are two ways to apply shading to alternate rows or columns —you can apply the shading by using a simple conditional formatting formula, or you can apply a predefined Excel table style …

In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. …

Testing whether conditions are true or false and making logical comparisons between expressions are common to many tasks. You can use the AND, OR, NOT, and IF functions to create …

In Visio Professional, you can color shapes depending on their data values. This is also known as the color by value data graphic. The coloring can be applied after you import data to shapes in …

Fill color & conditional marking. Highlight different choices and dates with Fill color. For example, you might have a column named "Requires Review". You could use color to highlight which …