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.
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.
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.
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.
The different color tones—created through conditional formatting color scales —make this clear without the need to display the corresponding numbers.
Avoid frustration and unintended formatting by learning how Excel applies conditional formatting rules.
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.