but what would I need to do if cell A1 was not complete but B1 was complete, I would need the formula to be transfer across the entire row and skip to the next cell if the outcome was not complete.
So you want to grey out the entire row whenever "Complete" is found within that row at any location. Then use this formula:
=ISNUMBER(MATCH("Complete",1:1))
You can either pre-select the range you want to apply conditional format to before applying, or you can click on the conditional format button and go to bottom option (Manage rules).
Here you can see the range the conditional format is applied to.
To further assist you I made a screen capture (working with a Dutch version) of the "Manage Rules" screen where you can see that the CF is activated if "Completed" is found in column A and it is applied to the first 20 rows.
I am trying to track progress of a projects, so each week an option is selected until the option 'complete' is selected, once that has been selected, I want the entire row to the right of the 'completed' cell to go grey.
So you want to grey out the entire row whenever "Complete" is found within that row at any location. Then use this formula:
=ISNUMBER(MATCH("Complete",1:1))
Best regards,
Trowa