1. Create a conditional formatting rule that says that if the value in cell M of a particular row is 1, then the cells in that same row in columns B-E should have a red background and white bolded text.
2. Use the format painter to apply this same conditional formatting rulse to the columns B-E for rows 4-273