conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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

Similar Threads

nested if statements using "AND" as well as "OR" 2
Conditional Formatting for one cell matching another with text 1
using row number or column letters in formula 5
Simple Formula Help 4
The "IF" Statement 1
IF Statement 1
Conditional Formatting with average formula and variance 9
conditional formatting update issue 5

Back
Top