MS Excel: Copying Condionally formated cells

Closed
Report
Posts
1
Registration date
Sunday August 9, 2009
Status
Member
Last seen
August 10, 2009
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

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?

thanks.

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
if the condition is $a$1="something" change it to
$a1="something"
0