conditional formatting

J

Jock W

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
 
T

Tom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top