Forum Discussion
Copying Conditional Formatting
I need to make one cell highlight when it is 10% over another cell. I know the format, however, I need to copy this format into a crap ton of cells.
How can I get it to work for the rest of my cells so i don't have to input it for every single one.
example:
B1 $100
B2 $110 =B2>=B1*1.1
B3 $200
B4 $220 =B4>=B3*1.1
B5 $300
B6 $330 =B6>=B5*1.1
I need B2 to change, B4 to change, & B6 to change. I can't copy the formatting because it only copies the original formatting and doesn't continue it down the line with new cells. Any suggestions?
I have 10 workbooks to do this to with about 200+ cells in each and I dont want to spend weeks on this.
4 Replies
MiMiMarie I copy conditional formatting frequently, successfully. So I guess I'm not understanding what you're asking, why you say you "can't copy the formatting because it only copies the original formatting and doesn't continue it down the line with new cells. "
I does look as if you're doing this conditional formatting for alternate rows (but maybe I'm misunderstanding your example).
Is it possible for you to upload a copy of the worksheet where this isn't working for you?
Hello mathetes,
This post stems from an earlier discussion found here:
https://techcommunity.microsoft.com/t5/Excel/Conditional-Formatting-Using-Percentages/m-p/1017548
