Excel: Conditional Formatting

Apply conditional formatting to help you assess your data relationships quickly.  The following steps walk you through how to apply conditional formatting:

  1. Open your Excel spreadsheet.
  2. Use your mouse to select the cells that you would like to format.
  3. Click the "Home" tab > Locate the "Styles" group. 
  4. Click "Conditional Formatting."
  5. Choose the type of formatting you would like to use on the data from the available selections.
  6. Use "live preview" to experiment with the different options until you find the one that best represents your data distribution.

Keywords: Green, Yellow, Red, Icons, Icon, Arrow, Arrows, Rule, Rules, Bars, Office, distribution, evaluate, distribute, graph, analyze, analysis 

Help Page Feedback

Did this content help you? *


What is your opinion about the content? *


Suggest new content or let us know how we can improve this content (optional):

If you desire a response, please provide your email address (optional):

Leave this field empty