Using Color to Organize
- Determine the major categories or groupings of information you use throughout your workday.
- Assign a particular color to each grouping. For example, assign red files for your To-Do Now items, green for your To-Do Later items.
- Use colored filing supplies to contain the materials for each grouping.
Sort in a Custom Order
- Select one cell in the column you want to sort.
- Press Ctrl + A, to select the entire region.
- Check the selected area, to make sure that all the data is included.
- On the Excel Ribbon, click the Home tab.
- In the Editing group, click the arrow on Sort & Filter.
- Click Custom Order.
How to Sort by color in Excel
- Open your spreadsheet and click the Data tab.
- Highlight your data range.
- Click the Sort button.
- Tick the My data has headers checkbox in the top right.
- Click the drop-down arrow next to Sort by and select the column with your color.
Then click the Sort button in the Data tab. Use the drop-downs to select the column or columns to sort by and check the box "My data has headers" if that applies. Use the Order drop-down menu to choose which order to sort the data in, whether largest to smallest or smallest to largest. Click OK when you are done.
Sort by dates
- Drag down the column to select the dates you want to sort.
- Click Home tab > arrow under Sort & Filter, and then click Sort Oldest to Newest, or Sort Newest to Oldest.
On the Data tab, click Filter. in the column that contains the content that you want to filter. Under Filter, in the By color pop-up menu, select Cell Color, Font Color, or Cell Icon, and then click the criteria.
You can take the literal meanings of these words: to sort means to arrange (something), in the context of Excel, you can sort a list or a range of cells. To filter - means to filter for something like we filter for trash, filter for gold. In excel filter mean to filter certain criteria (Alphabets, dates etc).
Sort in a Custom Order
- Select one cell in the column you want to sort.
- Press Ctrl + A, to select the entire region.
- Check the selected area, to make sure that all the data is included.
- On the Excel Ribbon, click the Home tab.
- In the Editing group, click the arrow on Sort & Filter.
- Click Custom Order.
The COUNT function in Excel counts cells containing numbers in Excel. You cannot count colored or highlighted cells with the COUNT function. But you can follow a few workarounds to count colored cells in Excel.
To set this rule, do the following:
- Select the data range, A2:A7.
- On the Home tab, click Conditional Formatting in the Styles group.
- Choose Highlight Cells Rules and then choose Greater Than.
- In the resulting dialog, enter 4. At this point, you could choose Custom Format from the With control's dropdown.
- Click OK.
There's no straightforward way to sum cells based on background color in Excel. For this example, the key is to assign a value for each background color, and use that value as the criteria for our SUMIF function.
To count the number of cells that contain text (i.e. not numbers, not errors, not blank), use the COUNTIF function and a wildcard. In the generic form of the formula (above), rng is a range of cells, and "*" is a wildcard matching any number of characters. Do you want to count cells that contain specific text?
Count number of cells with text with formula
Select a blank cell that you want the counting result showing in. 2. Copy and paste the formula =COUNTA(A1:D15)-COUNT(A1:D15) into the Formula Bar and then press the Enter key. Then you can see the total cell number showing in the selected cell.1. Select a range you want to count or sum cells by background color with conditional formatting, then click Enterprise > Count by Color. Click here for more on Count by Color.
