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

ok the copy color challenge is officially completed lol yeaaaaaaaaaa!!!!!!!

it works perfectly, time for the multi-flexible Sorting feature lol

hey just got in, going to test it out!!!

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.

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

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

forgot to mention, the only column i want to sort base on values will be Column A

You are awesome ???????????

Quote from Carim

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 ...?

Display More

these will be the regular colors ill be using

and yes that is a good starting point