Aug 28 2019 01:29 AM
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..
Aug 28 2019 05:04 AM
Aug 28 2019 05:10 AM
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.
Aug 28 2019 05:29 AM
Aug 28 2019 05:32 AM
Aug 28 2019 06:25 AM
Aug 28 2019 02:16 PM
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
Aug 28 2019 10:17 PM