Conditional formatting is a format, such as a cell shading or fontcolor automatically applied to cells if a specific condition is met(true). When the condition is met, a specific cell format is applied tothe cells to answer any queries you may have about your data. Findingduplicates is another great use for this tool:
- Open the SSGStudentMarks.xlsx workbook.
- Select the cells to which you would like to apply conditionalformatting.
- On the Home tab, locate the
Styles group. Click on the Conditional Formatting icon.
- Choose Highlight Cell Rules fromthe drop-down list.
- In the sub-menu, look for LessThan… (in this particular example, I need to locate values lessthan 40%).
- Type the value of 40% into thetext area provided on the left, as illustrated in the followingscreenshot:
- Choose the font color from the drop-down list on the right. I havechosen the red text color, but other formats are available by clickingon Custom Format… at the bottom of thelist, which will take you to the FormatCells dialog box.
- Note that the cells change color on the worksheet as you are makingchoices from the Less Than dialogbox.
- If I alter the % in cell E10 to41% after applying the conditionalformatting, the condition will not be met anymore and the format will beremoved from the cell.