Forum Discussion
How do I Multiply Conditional Formatting to Following Cells?
Hi, I don't know if it's possible that can I multiply a conditional format or a ruleset of conditions in a cell through following cells? I choose 3 different rules for formatting the c...
Copy the cell with the right settings and paste special, formatting on top of the other cells should work.
Thanks for your time but I already tried it before I came to this point. It doesn't change the source cell by special paste/formats option. I mean, if you use functions for conditional formatting, it only changes the target cell that you paste the format which copied from the other cell.
- I don't think I understand. But you can open the rules manager (Conditional format, Manage Rules...) and change the range to which a rule applies in that list.
- I have, but I did not understand the question.