Politics2 mins ago
Excel 2007 Conditional Formatting
3 Answers
I have a spreadsheet listing checks and I have applied a conditional format to a row so that it changes colour when a cetrain cell has the value of "0." Ma question is, how do I apply that to all the rows below it?
Ta.
Ta.
Answers
Best Answer
No best answer has yet been selected by THECORBYLOON. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Highlight the row where your conditional formatting has been set and then go to the menu bar and look for an icon which looks like a brush (about a quarter of the way along from the left). It is called format painter. Double click it. Then every cell you click on will adopt the format until you click the icon again. So you can click on the numbers down the left hand side and apply the formatting as you require.
If you only wanted to copy the format of one cell to another cell, you would only need to click the icon once. As soon as you click on the cell you want to copy the formatting to, it will copy the format then cancel the command.
If you only wanted to copy the format of one cell to another cell, you would only need to click the icon once. As soon as you click on the cell you want to copy the formatting to, it will copy the format then cancel the command.
Thanks for that, the format painter rings a bell but it's not doing what I want. I don't think it was clear what I want to do.
I have it so that when $G$7=0 the row turns yellow but what I want is the formula to change to match the cell so that $G$8=0 and so on. I tried what you said but it seems to have replicated the $G$7=0 in all the cells in column G.
I have it so that when $G$7=0 the row turns yellow but what I want is the formula to change to match the cell so that $G$8=0 and so on. I tried what you said but it seems to have replicated the $G$7=0 in all the cells in column G.
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.