Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting
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 -- Jock Waddington |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting
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. "Jock W" wrote: 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 -- Jock Waddington |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting
Thanks Tom.
Easy when u know how. -- Jock Waddington "Tom" wrote: 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. "Jock W" wrote: 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 -- Jock Waddington |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |