How Do You Apply Conditional Formatting In Excel?
• Input all of your data or download a practice file here. This is useful because conditional formatting is best understood by testing it on data you already have. While you can apply conditional formatting to empty cells, it is easiest to see if the formatting works by using pre-existing data. Click to enlarge • Click on the cell you want to be formatted. Conditional formatting only allows you to change font style, underline, color, and strike-through as well as borders and shading. You cannot change the font or the font size. Click to enlarge • Click “Format” then “Conditional Formatting” to begin the conditional formatting process. Click to enlarge • Click “Add >>” to use two conditions. For this example, two conditions are used to see how each one plays off the other. Excel allows up to three conditions per cell. If you only need one condition, skip the next step. Click to enlarge • Click “Add >>” one more time to set another condition, or click “Delete…” and choose which conditi
