Choose your language

Prime Number

Intermediate Exercise


Statement

Create a Function that counts the number of times a prime number appears in cells. Check the result with a Sub that sets the background color to green in each occurrence.


Suggested Concepts:

Remember that in most cases there is more than one way to solve the exercise.

Hint: Prime numbers are only divisible by themselves and by 1.


Show Answer

Download exercise Download answer



SuperExcelVBA.com is learning website. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. All Rights Reserved.

Excel ® is a registered trademark of the Microsoft Corporation.

© 2019 SuperExcelVBA | ABOUT

Protected by Copyscape