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