Question: Please I need help with this VBA exercise, thank you! We consider a square range of an Excel sheet consisting of the first 25 rows

Please I need help with this VBA exercise, thank you!

We consider a square range of an Excel sheet consisting of the first 25 rows and the first 25 columns. The first diagonal (ascending) is the one starting at L25C1 and ending at L1C25. The second diagonal (descending) is the one starting at L1C1 and ending at L25C25.

You are asked to choose 5 numbers between 1 and 25, denoted N1, N2, N3, N4 and N5 and then write a VBA program that :

Assigns the color corresponding to N1 to the cells the first diagonal ;

Assigns the color N2 to the cells of the second diagonal;

Assigns the color N3 to the cells of column 13 whose row is even.

Assigns the color N4 to the cells in column 13 whose row is odd ;

Assigns the color N5 to the cells of row 13 whose column is a multiple of 3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!