Automatic Formatting for whole row
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!!!
|