Create and Use a User-Defined Function (2marks) – the udf sheet is setup for creating andusing a user-defined function. Steps:
In the Visual Basic Editor, in module1 there is afunction already created called SUMCOLOR for you to edit.This function is similar to one in the notes except that instead ofthe color being given to sum the cells, the color is retrieved fromthe color of the cell given in the second argument. (1 mark)
Use the function SUMCOLOR to create formulas for cellsF3:F5 that sum the cells that are orange, blue, and green.(1 mark)
Function SUMCOLOR(RangeToSum As Range, CellWithColor As Range)As Long
Dim colorId As
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured