Application techniques of conditional format in Excel2013

Conditional formatting, which is useful in Excel tables, is a simple feature in conditional formatting-highlighting cell rules, allowing special values to be displayed in special colors for easy differentiation.

① Select the table data, click the menu bar-start-conditional formatting-highlight cell rules-equals.

② enter John in the Equals option box, and the color is selected as the reddish fill color.

③ the cell with the data at this time is John filled with light red.

④ again to the data for the Harry Green fill, the final effect of everyone look at the following figure.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join