Application techniques of conditional format in Excel2013

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.