Hello,
You can do this with conditional formatting. Conditional formatting is volatile so, to keep a fast running worksheet, the idea is to limit the area you apply it to. In the attached example I did the following:
- Select A2:D12
- Home tab > Conditional Formatting > New Rule
- Select a rule type: Use a formula to determine which cells to format
- Format values where this formula is true: =$D2="Confirmed"
- Pick the format you want
In the formula, the column is fixed by the $ sign but the row number is not, so it will automatically adjust for you down to row 12.