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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!