Color Rows According to Criteria in Microsoft Excel | AccountingWEB

Color Rows According to Criteria in Microsoft Excel

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.

Wait, there's more!
There's always more at AccountingWEB. We're an active community of financial professionals and journalists who strive to bring you valuable content every day. If you'd like, let us know your interests and we'll send you a few articles every week either in taxation, practice excellence, or just our most popular stories from that week. It's free to sign up and to be a part of our community.
Premium content is currently locked

Editor's Choice

WHAT KIND OF FIRM ARE YOU?
As part of our continued effort to provide valuable resources and insight to our subscribers, we're conducting this brief survey to learn more about your personal experiences in the accounting profession. We will be giving away five $50 Amazon gift cards, and a $250 Amazon gift card to one lucky participant.
This is strictly for internal use and data will not be sold
or shared with any third parties.