Color cells if a corresponding cell is colored

Closed
Report
-
Hello,

I have columns a and z. If I color column z, say Z45, then A45 in column A should automatically be filled of the same color in z45.

Note:Z45 will be blank and A45 will have some content in it.