Copy style from another column or set style dependant on the values in another column

How to copy the cell styles from another column (i.e. to paint the cells in the current column as their counterpart in the same row, from different column)?
or
How to create style on a cell from column I depending on the values of cells in other columns?

Please pour some wisdom on me!