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"

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!