Conditional Formatting

Anthony

All you need to do is Highlight "Column A" and apply Conditional Formatting to it. To do this:

1. Highlight "Column A"

2. Select the Format menu and click Conditional Formatting

3. In the Conditional Formatting dialog box set the condition for when the cell says Pass and when it says Pending as per your colour criteria by clicking Format.

NB The cell interior is formatted on the Patterns tab.

I have attached a spreadsheet to show you how it looks.

Hope this helps

Regards

Carlos

Hi Tony

Thank you for your question.

Try the following:

1. Select the cells in column A you wish to apply the conditional formatting to.

2. For Condition 1, select Cell Value is Equal to Pass (no need to include quotation marks) and then use the Format button to set the format for the cells (background colours are included under the Pattern tab).

3. Click the Add button, then for Condition 2 select Cell Value is Equal to Pending and then use the Format button to set the fomat for the cells.

I hope this helps.
Amanda