News

Learn how to color-code emails in Outlook by sender using Conditional Formatting. See what rule you can in View Settings to color code messages from a particular sender.
Outlook Calendar allows you to create appointments or meetings. Learn how to color code the Calendar in Outlook using Conditional Formatting.
Conditional formatting in Excel 365 uses tools like data bars, color scales, and icon sets to visualize data trends, making analysis more intuitive and actionable.
The different color tones—created through conditional formatting color scales —make this clear without the need to display the corresponding numbers.
How to apply the conditional format in Outlook Calendar With or without an appointment, applying a conditional format is easy, and Outlook applies the code automatically.
There is an easier way. Highlight cell a1:g7 and set conditional format style to 3-color scale. Set minimum number to -1, midpoint number to 0, and max number to 1. Much quicker method.
Excel's conditional formatting lets you customize how your data displays, from changing colors and shading to adding icons and more. Here's how it works.
With conditional formatting, you can easily apply color scales, data bars, or icon sets to your data, making it easier to gain the insights you need.
Gmail does not have conditional formatting. You can use filters to put email in different folders (what Gmail calls labels) or put it in different tabs along the top of the inbox.