Change row color without conditional formatting

  • I have 4 headers representing colors

    Date Paid = Green
    Date Delivered = Red
    Date Collected = Yellow
    Overweight Fee = Blue


    My data starts at row 3


    Date Paid starts at "F3"

    Date Delivered starts at "G3"

    Date Collected starts at "H3"

    Overweight Fee starts at "L3"


    To make it simple, if any type of value is inputted into these columns I just want the row to change color to the related headers and the rows to change colors again if I input values in other columns.


  • Hello and Welcome to the Forum :)


    Attached is your test file


    Hope this will help

    :)

    Files

    • Test Rurkz.xlsm

      (16.77 kB, downloaded 74 times, last: )

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

  • Hi,

    Maybe Worksheet Change event

  • hey royk


    the issue i was running into with conditional formatting was between Date Paid and Date Collected. So if the row changed green when paid, then yellow when collected, that would work perfectly but if it was vice versa the row will stay yellow and not turn green.

  • hey Carim I took a look at your file, I apologize, looks great, I forgot to mention I wanted to highlight the entire row, A3 to L3 etc... So if I input a value in Date delivered, the row is highlighted red. Then if I enter a value in date collected, the row will change to yellow, and when its finally paid, it will change to green. Sometimes it might be paid before collected, that means the row can change from green to yellow.......im really trying to have it setup so the colors can be overridden no matter what order a value is inputted if you get what I mean.....Appreciate it

  • Hello again,


    Not a big deal ... only a tiny modification ...;)


    Hope this will help

    :)

    Files

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

  • Hello,


    Once you have tested the macro ... feel free to share your comments ...

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

  • hey didnt see the notification reply until i checked manually.......carim you awesome!!!!! this exactly what i needed!!!!


    it seems to work in your file, here is my file, but i didnt get it to work in mine

    Files

  • Thanks for your file :)


    Do you need the macro to operate in some specific worksheets ... or would you like to have it for all your worksheets ...?

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

  • Well ... the file you are currently using was designed by Jon Wittwer for Vertex ...


    And you cannot have several similar events such as Worksheet_Change() within the same sheet ...

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

  • im a complete noob, so i have no idea what worksheet_change() is lol. I did however have someone create a macro for me if thats wha you are talking about.


    and yes if i can have it operate in all worksheets that would be awesome

  • im a complete noob, so i have no idea what worksheet_change() is lol. I did however have someone create a macro for me if thats what you are talking about ....

    Could you friend next to you who has already designed the first macro help you out ... ?;)

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

  • Could you friend next to you who has already designed the first macro help you out ... ?;)

    I'm not sure if he/she could, i posted the question on mrexcel around a month..and got a response for that macro...then I asked about changing the row color and the moderator told me to start a new post...I did and never got help for it. Believe it or not, you are the only person who has helped me with this situation....also forgot to mention wittwer from vertex, it was a free expense sheet i download around a year ago and modified it.

  • I'm not sure if he/she could, i posted the question on mrexcel around a month..and got a response for that macro...then I asked about changing the row color and the moderator told me to start a new post...I did and never got help for it.

    Believe it or not, you are the only person who has helped me with this situation....also forgot to mention wittwer from vertex, it was a free expense sheet i download around a year ago and modified it.


    Whenever I have a moment ... will drill down the workbook structure ... and try to find a complete workable solution :)

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