+ Reply to Thread
Results 1 to 15 of 15

Color Change with New Month

  1. 10-30-2017, 09:32 AM #1
    waqarqrl
    waqarqrl is offline
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    178

    Color Change with New Month

    Dear Excel Fox
    I always appreciate your helping nature, Need a help again.
    I have a sheet where i enter monthly fee, i want when next month arrive color of Month automatically change (which i change to gray in example attached sheet).

    It would help us to sort out pending fees.

    Regards
    Waqar
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-30-2017, 09:40 AM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,485

    Re: Color Change with New Month 

    Please Login or Register  to view this content.
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 11-01-2017, 02:53 AM #3
    waqarqrl
    waqarqrl is offline
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: Color Change with New Month

    thanks Alot davesexcel
    I tried this many times but it not worked, may be i am doing something wrong , can u please further elaborate.

    Regards
    Reply With QuoteRegister To Reply
  4. 11-01-2017, 08:15 AM #4
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,485

    Re: Color Change with New Month

    Sure, run the code, when it finds the word "Month" it will color the column.
    Reply With QuoteRegister To Reply
  5. 11-07-2017, 05:45 AM #5
    waqarqrl
    waqarqrl is offline
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: Color Change with New Month

    Dear Davesexcel
    Thanks alot I upload file again just need Amount Colomn in red color when next Month Change.

    REgards
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 11-08-2017, 02:54 AM #6
    waqarqrl
    waqarqrl is offline
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: Color Change with New Month

    Dear davesexcel
    Plz help.
    Reply With QuoteRegister To Reply
  7. 11-08-2017, 05:45 AM #7
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,485

    Re: Color Change with New Month

    Find the last column with the word amount,

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 11-08-2017, 08:28 AM #8
    waqarqrl
    waqarqrl is offline
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: Color Change with New Month

    Thanks alot
    I apply this code but it didnt change the color of amount colomn, although i change the date of system, if u please upload the sheet.
    Regards
    Reply With QuoteRegister To Reply
  9. 11-08-2017, 12:03 PM #9
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,485

    Re: Color Change with New Month

    The code will find the last column that has "Amount" in it, and color it,
    Reply With QuoteRegister To Reply
  10. 11-10-2017, 01:01 AM #10
    waqarqrl
    waqarqrl is offline
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: Color Change with New Month

    Sir please upload the sheet i will be thankfull to you, so that i can see where it color. please
    Reply With QuoteRegister To Reply
  11. 11-10-2017, 05:54 AM #11
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,485

    Re: Color Change with New Month

    I would just be uploading the same workbook as you did.
    Just run the code from the same workbook as you provided.

    You will notice there are two lines that I have commented out, they unprotect the sheet and then protect it again, you have to uncomment the lines in order for it to work.
    Reply With QuoteRegister To Reply
  12. 11-14-2017, 10:03 AM #12
    waqarqrl
    waqarqrl is offline
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: Color Change with New Month

    Sir i have Upload sheet with code ... plz check and indicate where it works and how ?
    Regards
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  13. 11-14-2017, 12:13 PM #13
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,485

    Re: Color Change with New Month

    You can use a worksheet change event.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  14. 11-24-2017, 02:21 AM #14
    waqarqrl
    waqarqrl is offline
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: Color Change with New Month

    Not working Properly......
    Reply With QuoteRegister To Reply
  15. 11-24-2017, 02:28 AM #15
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,426

    Re: Color Change with New Month

    "Not working properly" is not at all helpful to those trying to assist you. Please give specific detail: in what way is it not working? What isn't it doing? Are you getting error messages?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Color Change with New Month
    By waqarqrl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2017, 05:39 PM
  2. Condition Formatting: Change color when month change (oct = red, Nov = blue)
    By Flyinace2000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-28-2012, 12:20 PM
  3. Change color of current month only
    By Kutar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2010, 01:13 PM
  4. [SOLVED] Change Cell Color if in current Month
    By Leslie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] Change Cell Color if in current Month
    By Ron de Bruin in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 07:05 AM
  6. Change Cell Color if in current Month
    By Ron de Bruin in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 06:05 AM
  7. [SOLVED] Change Cell Color if in current Month
    By Leslie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1