Change row color without conditional formatting

  • i mean have the row turn green when i input the value in date paid specifically in those spreadsheets

    No problem ...;)


    Attached is your Version 4 file


    Hope this in line with your ' COLORFUL ' expectations ...8)

  • Should the Copy Color Challenge be out of the way ... this would mean .. we are only left with the multi-flexible Sorting feature ...


    Once you have fully tested ( and approved ... ) the Change Row Color features... we will move on ...:)

    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:)

  • Sorry ... forgot to mention :


    1. Use Mouse Left Double-Click to Sort Ascending on Any Header Title


    and


    2. Use Mouse Right Click to Sort Descending on Any Header Title


    Hope this will help

    :)

    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:)

  • ok so are you ready lol


    the sorting works, but its sorts what values are in the columns cells. what im aiming for if possible is to sort the row colors instead


    also i noticed something when replicating the overweight fee to the overweight sheet.


    it does this only when date delivered, date collected and overweight fee are is filled in.


    that function works perfectly!


    but lets say i fill in date delivered, date paid, date collected, and then overweight fee, it doesn't replicate.

  • Hello,


    Two separate issues :


    1. Sorting : when you say " sort the row colors " not sure to understand - because, as you know the colors are generated by the values ... so sorting the Values should also sort your Colors - thanks for attaching a sample file ...


    2. Copying : when you explained your objective was the copy should only be done IF Date Paid (Column F) was empty ...

    So are you telling me that this logic is now different ....!!!


    Could it be that what determines the Copy is in fact ... the Sequence Used to Fill in all your Dates ...????


    I am confused ... and YOU are the ONLY person who KNOWS ... !!!:)

    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:)

  • Damn I never got this notification....


    1. I will double check the sorting again when i get home. I think what's happening is

    Let's say

    date delivered is filled in for 4 rows(red)


    And for another 4 rows(yellow)


    Date delivered and date Collected is filled in.


    When I click on date delivered, instead of grouping the red rows together it grouped


    2 row red at the top

    1 row yellow

    2 rows red

    1 row yellow


    Instead of grouping all red rows at the top and all yellow rows at the bottom depending on ascending or descending.


    2. That logic is correct if I deliver a bin and pick it up without getting paid and it copies to outstanding bins


    But for overweight Fee, there is no restrictions, when i type a value in that cell, it copies right away

  • Hello,


    To clarify as much as possible ... why don't you attach a sample file with fake data ... to illustrate your points ...;)

    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:)

  • just got in, here i go!!! lol


    ok attach is fake data


    as you can see there is different rows colored in random order. when this is ready ill have 37 rows ready to be filled in which will continue to grow, and instead of scrolling up and down looking for a paid bin, a delivered bin or a collected bin, i can sort them by color from the top.


    Now lets say i want to organize all the row paid bins in green. I will double click the Date Paid Green Header and it will sort them from the top.


    Now lets say i want to organize all the row delivered bins in red. I will double click the Date Delivered Red Header and it will sort them from the top.


    the Date Collected Yellow Header and Overweight Fee Blue Header will follow the same function


    "Because, as you know the colors are generated by the values ... so sorting the Values should also sort your Colors"


    what i noticed is, when i doubled click the headers, it sorts the value but it doesnt group and sort the colored rows together. Is it possible to sort the colored rows without using the inputted values to sort?




    Now for the replication to other sheets


    the function to copy from the Main Sheet to Outstanding Sheet is correct!


    "should only be done IF Date Paid (Column F) was empty"


    but


    the function to copy from Main Sheet to Overweight Bins is different


    "should only copy IF Overweight Fee (Column L) was filled in"

  • i hope that helps :)8)


    For sure it helps a lot ... !!!


    Thanks for all the clarification efforts ...


    Next step is to "translate" your objective into some working macros ...


    Will get back to you as quickly as possible ;)

    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 again,


    Before diving into some quite complex issues, can we agree on a couple of initial points :


    1. The 4 Colors you have picked are the ones to be used (and RGB coded) ... i.e. you do not intend to regularly change colors ...


    2. What would be your ' natural sequence ' for these 4 Colors ?

    seems to me... you would go with : Green - Red - Yellow - Blue ... is that a good starting point ...?

    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:)

  • these will be the regular colors ill be using


    and yes that is a good starting point

Participate now!

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