I have a conditional format where if a cell in a row has a specific value, it will set the format to highlight the whole row. I would like to apply this conditional format to each row in my worksheet without re-entering for each row. Prior to Office 2007, although tricky, I could copy the row with the format to other rows. In 2007, it seems to lock me into the condition being against the initial cell, not allowing it to be row specific.
Does anyone know how to quickly apply this conditional format on a row by row basis?