Color line if condition meet in Excel

To color a line if a cell has a specified value go to:

• Conditional Formatting
• New Rule
• Use a formula to determinate witch cells to format
• Format values where this formula is true
• select the cell with the desired value and enter the condition
• select the formatting you want (background color)
• select the whole table

Example:

We have a table with column A to Z and we want to color each row if the cell from column S has the value "Shipped"

Formula should be: =$S1="Shipped" and Applies to =$A:$Z