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 (0)
Please login or register to join the discussion.
There are currently no replies, be the first to post a reply.