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
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.xlsRE: 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
