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.

You may like these other stories...

Continuing its efforts to simplify accounting procedures, the FASB has issued a proposed Accounting Standards Update on customer fees paid in a cloud computing arrangement. The newly-proposed update (Intangibles—...
How are you planning? What tools do you use (or fail to use) for forecasting? PlanGuru is a business budgeting, forecasting, and performance review software company based in White Plains, N.Y. AccountingWEB recently spoke...
Event Date: October 30, 2014, 2 pm ETMany Excel users have a love-hate relationship with workbook links. For the uninitiated, workbook links allow you to connect one Microsoft Excel spreadsheet to other spreadsheets, Word...

Already a member? log in here.

Upcoming CPE Webinars

Aug 26
This webcast will include discussions of recently issued, commonly-applicable Accounting Standards Updates for non-public, non-governmental entities.
Aug 28
Excel spreadsheets are often akin to the American Wild West, where users can input anything they want into any worksheet cell. Excel's Data Validation feature allows you to restrict user inputs to selected choices, but there are many nuances to the feature that often trip users up.
Sep 9
In this session we'll discuss the types of technologies and their uses in a small accounting firm office.
Sep 11
This webcast will include discussions of commonly-applicable Clarified Auditing Standards for audits of non-public, non-governmental entities.