ACECQA has been established to guide the implementation and administration of the National Quality Framework, and to ensure national consistency. Information on the NQF, including information sheets and sector support material, is available on the ACECQA website.
There are three ways to highlight cells. 1  Click, hold and drag your mouse. 2  Click on the first cell in the range, and then hold down your Shift key while you click the last cell in the range.  Enter the range in the Name Box.
1. Open the Excel table where you need to count cells by color and run the All Colors tool by clicking on its icon. 2. Select the range in your table and you will see its address in the Select Range field.When you count cells by color you can choose a range in Excel that contains both text and numerical values.3. Now you need to define if you want to calculate by fill or font color of the selected cells. 1  Click the Background radio button to count the selected data by the fill color.. Open the Excel table where you need to count cells by color and run the All Colors tool by clicking on its icon. 2. Select the range in your table and you will see its address in the Select Range field.