MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Conditional formatting


Posted by Hemant on September 10, 2001 7:37 AM

Hi

I have a problem where. I have designed a stock system. If a job is completed on the system the a cell (N8) turns to "YES" which refers to the job completed (using an if statement). What i want to do is if that cell turns Yes then i want that whole row to turn (including the yes cell) to a different colour to signfy that a job is complete. I have tried conditional formatting and have only been able to change the ("YES" CELL N8) cell. If anybody knows how to do this please could you email me thanks.


Posted by Tom Urtis on September 10, 2001 7:46 AM

To conditionally format the entire row 8, highlight the entire row by clicking on the row header, then go to Format > Conditional Formatting > select "Formula Is" from the drop down arrow, and enter the formula:
=$N$8="YES"
then choose your formatting options and click OK.

Tom Urtis

Posted by Aladin Akyurek on September 10, 2001 7:48 AM

Hemant,

Click on row 8 (via row selector).
Activate Format|Conditional Formatting.
Select "Formula Is" for Condition 1 in the Conditional Formatting window.
Enter the following formula:

=$N$8="Yes"

Activate the Format button.
Select a color on the Patterns tab.
Activate OK button.

Aladin

================