hello,

I want to conditional format my table based on a formula in another sheet, as i want to be able to quickly change the formula without having to go into the conditional formatting.
f.e.
AND(K$1>=$I8;K$1<=$J8;$E8="brand1";WEEKDAY(K$1;2)<>7)
AND(K$1>=$I8;K$1<=$J8;$E8="brand2";WEEKDAY(K$1;2)<>7)
--> i am using the same formula but for different brands --> different Colours so it would be way easier to change the formula only once and automate the linking to the brands and the conditional formatting

does anyone know how to do that?

any help and tips would be very much appreciated!

thanks cricked