+ Reply to Thread
Results 1 to 3 of 3

using excel VBA find and higlight in red all prime numbers in a table of numbers

  1. #1
    Registered User
    Join Date
    09-10-2017
    Location
    South Africa, Cape Town
    MS-Off Ver
    2010
    Posts
    1

    using excel VBA find and higlight in red all prime numbers in a table of numbers

    using excel VBA i have to generate a table of numbers counting anti clock wise with one in the middle and highlight prime numbers in red in the processs.

    At the moment i have came up with code to generate the table of numbers anti clockwise , my problem now is to highlight red all prime numbers .

    here is my code :
    Please Login or Register  to view this content.
    The out pout should be similar to the following image :
    image.png

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: using excel VBA find and higlight in red all prime numbers in a table of numbers

    Hello Try this
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: using excel VBA find and higlight in red all prime numbers in a table of numbers

    Another one :
    Please Login or Register  to view this content.
    Attached Files Attached Files
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Prime numbers macro
    By kaue in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-17-2020, 09:08 AM
  2. How to get functions about prime numbers in Excel 2013?
    By Terminatrix in forum Excel General
    Replies: 1
    Last Post: 04-21-2014, 11:49 AM
  3. Highlight all prime numbers in column
    By bluecat2013 in forum Excel General
    Replies: 3
    Last Post: 02-21-2014, 01:19 PM
  4. Higlight duplicates positive and negative numbers
    By magman1984 in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 02-13-2014, 01:07 PM
  5. Higlight duplicate numbers
    By nakata75 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-22-2012, 11:56 AM
  6. Prime numbers
    By Gearcutter in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-08-2007, 09:03 AM
  7. [SOLVED] Prime Numbers
    By Flyone in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2005, 10:25 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1