Posted by Hemant on September 10, 2001 7:37 AM
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.