How can I color rows based on the cell value of one cell in each row? That
is, if I use conditional formatting to test the value of cells in column P, I
can color cells in that column with conditional formatting, but I want all
cells in each row to have the format of the cell in column P of that row.