Question: The macro should also add with your full name in cell B1 and widened column B so that your name is completely displayed. (please help

The macro should also add with your full name in cell B1 and widened column B so that your name is completely displayed. (please help me with this part)

NEED HELP WITH CREATING A TWO PART MACRO

I did the first step but can someone help me with the second set with displaying the name.

1. Create a macro which changes the font color of the numbers in column A (up to 100 rows) to GREEN if the number is even and to RED if the number is odd. (60%)

2. The macro should also add with your full name in cell B1 and widened column B so that your name is completely displayed.

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!

On 1 January 20X4, Dart Incorporated commenced business operations. The following information is available to you: 20X6 $45, 000 20X4 20X5 20X7 $ (300, 000) Earnings (loss) before tax Tax rate...

Topic & ContentThis is the fun part! Within appropriate limits ( nothing derogatory or of a sensitive nature ) , you may choose any topic. The only requirement is that the chosen subject matter...

Here is what the output should be Welcome to Battleship! Enter the board height (1 to 99): 8 Enter the board width (1 to 675): 5 Enter the number of ships (1 to 9): 3 My Ships: A B C D E 0 ~ ~ ~ ~ ~...

PROJECT DESCRIPTION Patrick Fitzgerald is the director of Career Development at Finn Technical Institute, a local community college. The Institute offers workshops on resume writing, interview...

Liting Wang Shelly Cashman Excel 2013 Chapter 10: SAM Project 1a Submission #2 Score is 79 out of 100 1. Go to the Event Schedule - 2018 worksheet and use the password J@Nuary18 to unprotect the...

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

Liting Wang Shelly Cashman Excel 2013 Chapter 10: SAM Project 1a Submission #2 Score is 79 out of 100 1. Go to the Event Schedule - 2018 worksheet and use the password J@Nuary18 to unprotect the...

Instructions SC EX19.10a Mac (6) Saved to my Mac Draw Design Layout References Mailings Review View Cury Go. 22 ' ' Aalbcodes ADA AaBocede Bodyy ABC AaBb Abebe incorrect S1 P Shelly Cashman Excel...

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

Step 1: Import and Clean Up Text File Download starting student Excel file and the text file. Open the starting Excel file and navigate to Sheet1. Import the text file by using the Get External Data...

Use Geogebra to work on the topics of Calculus including: calculate derivatives, use rectangle sum to understand integrals, infinite Integrals, definite integrals to calculate areas, improper...

The air conditioner in a house or a car has a cooler that brings atmospheric air from 30oC to 10oC both states at 101 kPa. If the flow rate is 0.5 kg/s find the rate of heat transfer.

Use research resources (be sure they are credible sources), and provide an essay on one of the following topics: Sending Mixed Signals: When Nonverbal Messages Conflict with Verbal Communication...

A temporary difference that results in a deferred tax liability will reduce taxable income the originating year. for two years after in the year following in the year before in

At the beginning of 2018, Ms. P purchased a 15 percent interest in PPY Partnership for $21,000. Ms. P's Schedule K-1 reported that her share of PPY's debt at year-end was $15,000, and her share of...

What is the role of the Council of Economic Advisers (CEA) as it relates to fiscal policy? Class assignment: Determine the names and educational backgrounds of the present members of the CEA.

KEY QUESTION Briefly state and evaluate the problem of time lags in enacting and applying fiscal policy. Explain the idea of a political business cycle. How might expectations of a near-term policy...

KEY QUESTION Assume that (a) the price level is flexible upward but not downward and (b) the economy is currently operating at its full-employment output. Other things equal, how will each of the...