• 409K Members
• 10.2K Online
• 466K Conversations

New Contributor

# 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 cells in the 3rd row. and this list is endless I mean, I cant write down all 3 rules for each cell.

I'm looking for an option like the format painter. Copy the format of the cell and then paste it where ever you want.

7 Replies

# Re: How do I Multiply Conditional Formatting to Following Cells?

Copy the cell with the right settings and paste special, formatting on top of the other cells should work.

# Re: How do I Multiply Conditional Formatting to Following Cells?

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.

# Re: How do I Multiply Conditional Formatting to Following Cells?

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.

# Re: How do I Multiply Conditional Formatting to Following Cells?

I have, but I did not understand the question.

# Re: How do I Multiply Conditional Formatting to Following Cells?

Not sure I understood the logic exactly. For such sample

you may select entire column C and apply 3 rules to it with formulas like

``````yellow:
=(\$C1<\$A1)*(\$C1>0)

red font
=\$C1>\$B1

blue
=(\$C1>=\$A1)*(\$C1<=\$B1)*(\$C1>0)``````

That's in attached

# Re: How do I Multiply Conditional Formatting to Following Cells?

I'll try. thank you.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies