Hello,

I would like to have my spreadsheet automatically format an entire row, rather than only a single cell. Given a criteria in one cell, I would like the cell style (normal/good/bad/neutral) to change for the full row.

For example:

If I have dates in column A, phone numbers in B, name in C, and status in D, I would like each row with status reading "Confirmed" to have the "good" cell style. I can format so Column D does this, but can't figure out how to set it up so the whole row changes.

Any help would be appreciated, thanks!!!

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.

Attached Files

Book1.xlsx (9.0 KB, 25 views)

You're a genius. Thank you so much, that was exactly what I was looking for.