Hi Scott,

Try this -

1. Select the first row of cells and then click on Home Conditional
Formatting New Rule (I selected cells A1:H1)
2. Use the Rule Type -- Use a formula to determine which cells to
format.
3. Type the formula in their as =SUM($B1:$H1)<7 (Note: 7 is the total
number of systems where the patch must be applied, that is number of
columns. If you have more columns then change this number accordingly.
4. Define the formatting as you need that is the fill or fonts that
you need when above condition is true. Click on OK.
5. Now Copy the cells from A1:H1.
6.Select all the rows where you want the formatting to be done the
same way and do Paste Special Paste Special Formats.

You should be able to see all the rows where all columns do not
contain 1 highlighted in your selected format.

-AG