How do i Conditional formatting whole row
I
pages 09-OTHER, OS X Mountain Lion (10.8.2)
I
pages 09-OTHER, OS X Mountain Lion (10.8.2)
How do I set conditional formatting to set the color of all cells in a row if the test condition is true for only one of those cells?
For example, I want the whole row to be highlighted yellow if the date in the first cell falls in January. I have non problem getting cell with the date to format correctly. It's the other cells that I want to change.
Conditional formatting rules apply only to the cell to which they are attached. They depend on comparing the value in that cell to either a fixed value, or to the value in another cell.
To format a row of cells, you need to attach a conditional format rule to each of those cells.
But you can create the appearance of setting the colours of all of the cells by using a second table. Here's an example.
Table 1 is the larger table on the left, the one we want to appear to have the conditional formatting. Table 2, the single column table, is the table that is actually given the conditional fill colour. Each cell in table 2, except the header row cell, A1, contains the formula shown above the tables, and the rule shown below the tables.
The rule sets both the text and fill colours to the same shade of red when met.
Four more steps are needed before the formatting will appear to have been done to table 1.
Result shown below:
Regards,
Barry
How do i Conditional formatting whole row