+ Reply to Thread
Results 1 to 2 of 2

Change Cell Color based on daily entry

  1. #1
    Registered User
    Join Date
    04-20-2008
    Location
    New York City
    MS-Off Ver
    2003
    Posts
    38

    Change Cell Color based on daily entry

    I am sure VBA can do this, just don't know how.

    I have a list of items that are sold through out the week. I want the item cell in column A to change to GREEN if that item was NOT sold by either John or Jane on any ONE of the days.

    For instance say, John sold a button on May 25 and Jane didnt. Cell A3 would turn RED. Both John and Jane would have to sell 0 on the same day on any item in that week in order for the Cell in collumn A to turn green or else it would turn RED.

    Another example lets say both John and Jane did NOT sell a Button on May 25, then cell A3 would stay green for the rest of the week even if they sold a Button on each day for the rest of the week. The 'green' criteria was met on the first day.

    See attachment. Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Change Cell Color based on daily entry

    I can't remember, can you use conditional formatting to do that in 03? Set the cell to be red if the sum of columns N and O in that row are greater than 0.
    Is your code running too slowly?
    Does your workbook or database have a bunch of duplicate pieces of data?
    Have a look at this article to learn the best ways to set up your projects.
    It will save both time and effort in the long run!


    Dave

+ Reply to Thread

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