Results 1 to 5 of 5

Changing the back color of the cells using vba

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    882

    Changing the back color of the cells using vba

    Hi guys

    Please see attached the workbook. The result appears in the sheet when the user click on Enter button in the form . Now I also want to add the code that will change the background color where date appears in the cells. If the todays date is 10months after the date in the cell then the back color of that cell should be amber and if the date is 12 months after the cell date then backcolor should be red. So I want to check all cells where date appears and in the code we have to check from column B2 to max columns where data appears and upto usedrange in the sheet.

    I hope anyone can help me to write code so that when the user click Enter button in the userform then it should change the back color of the cells depending upon the date calculations.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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