Color Rows According to Criteria in Microsoft Excel

Blogger
Share this content
0

You can use coloring to isolate data in lists and to differentiate between various types of data.

Make sure the list is set to AutoFilter.

  • Filter the year 1996 according to the following criterion – from the drop-down list for the Year field, select 1996.

  • Select a cell in the list of data – press Ctrl+* (select the current region).

  • From the Formatting toolbar, select Fill Color, and then select any color.

  • Filter the year 1997 according to the following criterion – from the drop-down list for the Year field, select 1997.

  • Select a cell in the data list, and press Ctrl+* (select the current region).

  • From the Formatting toolbar, select Fill Color, and then select a different color from the one you selected before.

  • Turn off AutoFilter.

Replies

Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.