How do I Multiply Conditional Formatting to Following Cells?

Copper Contributor

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? 

 

clipboard_image_0.png

 

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.

 

I added the example.

 

Thanks in advance..

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

@Jan Karel Pieterse 

 

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.

@Jan Karel Pieterse 

 

I already added example file. You can check it out.

I have, but I did not understand the question.

@Serhat_K 

Not sure I understood the logic exactly. For such sample

image.png

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

I'll try. thank you.