conditional formatting

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional Formatting

Conditional Formatting

resolvedResolved · Low Priority · Version Standard

Anthony has attended:
Excel Advanced course

Conditional Formatting

Hi

In Column "A" on an Excel Workbook I have the formula =IF(OR(G6="Pass",OR(I6="Pass")),"Pass","Pending"). I now also want to apply a conditional format to column "A" to change the background colour of a cell depending on the result of the formula. If the word Pass is returned i want the cell background to be Green. If the word Pending is returned i would like the cell background to be Orange.

If this possible? I have been scouring the Internet but not found anything that will make it work.

Your help would be greatly appreciated.

Kind Regards

Tony Duggin

Edited on Fri 29 Feb 2008, 16:33

RE: 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

Attached files...

Pass Pending Conditional Format.xls

RE: Conditional Formatting

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


 

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips


Server loaded in 0.09 secs.