conditional formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jock W - 24 May 2006 11:16 GMT

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

Signature

Jock Waddington

Reply to this Message

Tom - 24 May 2006 11:28 GMT

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.

> 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
[quoted text clipped - 3 lines]
>
> tia

Reply to this Message

Jock W - 24 May 2006 11:58 GMT

Thanks Tom.
Easy when u know how.

Signature

Jock Waddington

> Jock,
> You should be able to highlight column G, then drag over to the other
[quoted text clipped - 9 lines]
> >
> > tia

Reply to this Message