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.
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.
Color Scales Especially useful for spreadsheets with large data sets The Color Scale format uses different color gradients to highlight your cells from lowest to highest.
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.
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.