Results 1 to 2 of 2

Turn part number in column A green text if conditions are met

Threaded View

  1. #1
    Registered User
    Join Date
    10-23-2018
    Location
    warwickshire
    MS-Off Ver
    2010
    Posts
    5

    Turn part number in column A green text if conditions are met

    Hi new user here ,Please could anybody help me with a problem with excel . I will try to explain. I have a excel sheet with a lot of data on in column A I have part numbers In column G is the vendor column is date and column J is the reject or accept column.
    What I want to do is when I put a part number into column A the number text will appear as green text if that part number with the same vendor accepted and done in this year has bee done more than 5 times. I hope this makes sense.
    Basically if the part number has been entered more than 5 time in a year from same vendor and passed I want it to appear green.
    I have attached the workbook that I am using.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Turn off Error Checking (green triangle) for column A
    By jduong93 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2017, 09:51 PM
  2. Lookup, rank, if x = 1 turn cell green
    By lstar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2015, 09:37 AM
  3. Counting Number of Cells That Are Green in a Column
    By skratchmo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2013, 06:04 PM
  4. How to turn certain cells green
    By sharkman1912 in forum Excel General
    Replies: 4
    Last Post: 07-13-2012, 06:12 PM
  5. turn red or green
    By devilonline in forum Excel General
    Replies: 2
    Last Post: 09-27-2011, 11:31 AM
  6. If all 3 cells say yes want next field to turn green
    By vanaaken in forum Excel General
    Replies: 6
    Last Post: 04-15-2008, 02:38 PM
  7. turn off green triangles in Excel 2002?
    By Ron in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-19-2005, 10:06 AM

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