Row color change if specific cells have any value

  • so I have a work sheet that was put together by someone here a long time ago. I realized I have 2 tweaks I want to do specifically for this file, hopefully some can help me out, and if all goes well ill like to merge another file to work with this. but let's focus on this first.


    my table runs from A2 to L2, my headers are in row 2, and my data info starts at row 3


    So on sheet 1, i currently have it set up if a value is inputted in column I, that row turns red. if a value is inputted in column J, that row turns green, and if a value is inputted in column K, that row turns yellow.( I want to keep this setup, but change the yellow to red)


    what I have now is if column I has any value, and column J is empty, and column K has any value the row turns yellow and copies to sheet 2 if those conditions are met


    what I want to change is basically the color from yellow to red, I'm guessing the row can stay red and still copy to sheet 2


    my 2nd tweak is if column I and J have any values in their cells, the row will stay green(of course) but will continue to stay green if I input any value to column K and will then copy to sheet 3 if those conditions are met.


    I tried playing with the formulas but I gave up. so here is my coding


    Sheet 1

  • Hello,


    Seems to me your original question was posted about 18 months ago ... ;)

    If initial Yellow becomes Red ...

    Does it mean that "initial Red" remains Red ... or does it turn Yellow :?:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Does it mean that "initial Red" remains Red ... or does it turn Yellow

    initial red will stay red and copy to sheet 2 (outstanding sheet) if Column I (Date delivered) and column K (Date Collected) has values and not turn yellow


    its great to see you man hope all is well!!!

    Edited once, last by Rurkz ().

  • the second tweak, since you have a better understanding



    currently your setup is if values entered in :


    Column I (Date delivered), turns the row red


    Column J (Date paid), turns the row green


    if these conditions are met and i enter a value in column K (Date Collected)


    ill like the row to stay green and copy to my completed sheet



    also is it possible to change the color for Column L from blue to yellow. i use to have it as a overweight tab but now ill just use it for notes

    Edited once, last by Rurkz ().

  • Hello,


    Had a quick look at the latest file Version 6.2 and the macro dated 11 Mar 2021 ...


    To make your life easier, the possibility to modify the background color to fill the rows had already been built-in ...


    In your Main Sheet, just go to cell K2 (Date Collected) ... and change background color to Red ...


    As a consequence, adding a date in any row of Column K will turn the respective row to the background color used in cell K2


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • so this whole time i thought it was in the coding but it was a simple color change in the header lol


    but your right, the consequence is anything i add in that column turns red. is it possible to turn it green if Date delivered and date paid is filled in? and still have the red color option if date paid is not filled in?

    Edited 2 times, last by Rurkz ().

  • Hello,


    To make sure my understanding is correct , let me recap :


    1. cell K2 remains Yellow and does not interfere with the input of Dates.

    2. After an input in Column K, Change Row color to Green if Date Delivered (Column I) And Date Paid (Column J) are BOTH filled in.

    3. After an input in Column K, Change Row color to Red if Date Paid (Column J) is Empty.


    Thanks for your confirmation

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • 1. cell K2 remains Yellow and does not interfere with the input of Dates.

    ( this function i wont need)


    2. After an input in Column K, Change Row color to Green if Date Delivered (Column I) And Date Paid (Column J) are BOTH filled in.

    (this is correct, and copy to outstanding and completed sheet)


    3. After an input in Column K, Change Row color to Red if Date Paid (Column J) is Empty.

    (this is correct and copy to outstanding sheet)

  • Thanks a lot for your confirmation :)


    As soon as I have a moment, will add the modifications and attach Test Final Bin Logs V6.3  ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • .........

    2. After an input in Column K, Change Row color to Green if Date Delivered (Column I) And Date Paid (Column J) are BOTH filled in.

    (this is correct, and copy to outstanding and completed sheet)

    .......

    Hello,


    Just noticed, while resuming your modifications, a brand new sheet : Completed sheet - (not present in my latest 6.2 Version)


    In order to be sure we are staying on the same wavelength, thanks for attaching your very last working workbook ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Carim

    Changed the title of the thread from “need help with row color change if specific cells have any value” to “Row color change if specific cells have any value”.
  • Hello again,


    If your working file is too big ....

    1. just make a copy of your file

    2. in the copied file, you can delete the majority of records ...


    Ten to fifteen rows are enough ... the most important is to keep the actual structure ...

    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Thanks for attaching your sample file :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!