conditional formatting

[Guest]

I have set up the condition that if, for instance, cell G7 has the text
"Yes", then all the text in the other cells in row G changes from red font
colour to black.
How can I copy this conditional formatting to all rows in the worksheet
without having to change the G7 to H7, I7 and so on manually?


tia

 

[Guest]

Jock,
You should be able to highlight column G, then drag over to the other
columns. Excel will show a drop down box after you drag the cells over...from
that drop down box select "FILL FORMATTING ONLY" - Excel will copy the
formatting over, but not the cell contents.

 

[Guest]

Thanks Tom.
Easy when u know how.