hello,

I neet to create an automatically foramting for one column according to
anoter colomn formating.

I want the cell formating to change in one colomn whenever the formating it
changing in another colomn.

how can I do it ?
(I know how to use conditinal formating but I didnt find it helpful in that
case)

thank you.
Michal