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.
If you want to highlight cells that contain certain text, you can use a simple formula that returns TRUE when a cell contains the text (substring) that you specify. For example, if you want to highlight any cells in the range B2:B11 that contain the text dog, you can use: =ISNUMBER(SEARCH(dog,B2)) Note: with conditional formatting, it's important that the formula be entered relative to the active cell in the selection, which is assumed to be B2 in this case.