Forum Discussion

Serhat_K's avatar
Serhat_K
Copper Contributor
Aug 28, 2019

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.

 

I added the example.

 

Thanks in advance..

excel
office 365

7 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 28, 2019

    Serhat_K 

    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

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Aug 28, 2019
    Copy the cell with the right settings and paste special, formatting on top of the other cells should work.
    • Serhat_K's avatar
      Serhat_K
      Copper Contributor
      Aug 28, 2019

      JKPieterse 

       

      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.

      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Aug 28, 2019
        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.

Resources