+ Reply to Thread
Results 1 to 12 of 12

Draw red circles in specific columns

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

    Draw red circles in specific columns

    Hello everyone
    I have a sheet of students marks and in yellow columns (in my file) I need to draw red circles on the cells on condition that :
    The mark is less than the mark in green cell in the same column ...In other words, if for example in cell G6 the mark is 38 and the minimum for that subject is in the green cell of the same column which is cell G5 .. so in this case I need to circle the cell G6
    Another condition is the text "Absent" ,,should be also dealed like that last case and draw circle in that cell (example : cell G9)

    Note I don't need to deal with all the columns (just yellow columns) and the minimum for each column existed in row 5

    Hope it is clear

    Thanks advanced for any help
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  2. #2
    Registered User
    Join Date
    09-24-2015
    Location
    Delhi, India
    MS-Off Ver
    MS Office 2013
    Posts
    65

    Re: Draw red circles in specific columns

    Hi,

    See the attachment.

    Thanks
    Rohit.
    Attached Images Attached Images

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

    Re: Draw red circles in specific columns

    Thanks a lot Rohit
    I know how to use the conditional formatting method
    My request is how to draw circles on the cells that applied to the conditions mentioned
    And I need also another code to remove these circles ..
    Thanks for reply

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

    Re: Draw red circles in specific columns

    Any help in this topic please?

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Draw red circles in specific columns

    Have you tried recording a macro?

    What part don't you know how to do?
    Entia non sunt multiplicanda sine necessitate

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

    Re: Draw red circles in specific columns

    I think recording macro will not be useful for me in this thread
    All what I need is to draw circles by code with the conditions mentioned and another code to remove all circles if I need to get rid of them
    Thanks for reply

  7. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Draw red circles in specific columns

    But if you recorded a macro, you'd know how to draw a circle in code. You'd find that a shape has Left, Top, Width, and Height properties, and so do ranges.

    You already know how to write a loop to test cells.

    You may need help, but you don't need someone to do this for you.

  8. #8
    Registered User
    Join Date
    10-18-2015
    Location
    Lisbon, Portugal
    MS-Off Ver
    2010
    Posts
    38

    Re: Draw red circles in specific columns

    Greetings,

    To draw circles in each cell.

    You have to adapt for your needs as to just circle the cells you would like accoding to your IF CLAUSE.

    Please Login or Register  to view this content.
    To delete shapes just in case you are tired of watching red dots:

    Please Login or Register  to view this content.
    Hope it helps.

    Regards,
    Daniel

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

    Re: Draw red circles in specific columns

    Thanks a lot Mr. shg for guiding me and for adivce ..
    In fact I need professional solutions from experts to learn more and more (there are more tricks in your solutions .. I'm learning excel vba for fun !!)

    Thanks a lot Mr. Daniel for great code
    But it deals with one column and there is no apply to the conditions

    Need to deal with columns ("G - H - J - K - M - N") and with the criteria mentioned in first post
    Thanks a lot for both of you

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

    Re: Draw red circles in specific columns

    Waiting for professional solution ..

  11. #11
    Registered User
    Join Date
    10-18-2015
    Location
    Lisbon, Portugal
    MS-Off Ver
    2010
    Posts
    38

    Re: Draw red circles in specific columns

    Greetings,

    I think this works now:

    Please Login or Register  to view this content.
    Regards,
    Daniel

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

    Re: Draw red circles in specific columns

    Mr. Dafer
    Thanks a lot for this great and hepful solution
    Although it is not the whole request but I could change it to suit my demands
    Thank you very very much

+ 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. Replies: 9
    Last Post: 06-24-2014, 02:56 PM
  2. Replies: 1
    Last Post: 02-05-2014, 08:36 PM
  3. Draw out listings in table #1 based on specific criteria
    By Melvinrobb in forum Excel General
    Replies: 2
    Last Post: 07-24-2012, 02:45 PM
  4. How to draw a circle in excel with specific radius
    By Mile in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-13-2006, 06:10 AM
  5. Using VLOOKUP to draw data from two columns
    By Dan in forum Excel General
    Replies: 5
    Last Post: 06-25-2005, 08:05 AM
  6. I want to draw a line through the columns of a chart, plot the o.
    By Dewey in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-14-2005, 08:06 PM
  7. how do I draw a line in a chart at a specific location
    By Charles in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-07-2005, 09:06 PM

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