Posts by Rurkz

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

it works now!!!! awesome!!!!

the last color change option is for outstanding bin and overweight bin spread sheet.

simply have those rows change green when i input a value in date paid.

its not functioning on my end, the row is stuck on green....even if i input a value for date collected and overweight fee

ok just looked over the file,

replications to other sheets works perfectly

along with the colors

but when i inputted date delivered(red) to date paid(green) to date collected(yellow), it didnt change yellow.

sorry got distracted by phone calls

Quote from Carim

Step 1 ... the Copy Color Challenge ...

Attached is your Version 2 ...

One issue which might cause a new headache :

Is there something which needs to happen whenever you come back to an existing record located in the Master Sheet to update a field...

Are you expected this update to be reflected in any other worksheet ... talking about the Data ...not about he Colors ...

see attached file ...

Hope this will help

Display More

Sorry was distracted from phone calls, I decided to delete the master sheet, won't need to keep track of previous jobs if they are done

Changing colors will happen in the master sheet and the only change of color in the other sheet will happen when i input a value in date paid, they will turn green.

I just realized something, all the row values should be replicated from the main sheet to the overweight bin sheet except date paid column So when the overweight is paid, the row will turn green from blue....

That is AWESOME!!!!!!!!!!!!!!!

Ok let's get that out of the way

That would be soon awesome, there is one final step. I'm not sure if it's possible.

Online iv seen people use a click function on their column headers to sort a column instead of using the sort & filter. I was wondering if this is possible for rows.

For example let's say I want to sort date delivered bins, I can just click on the date delivered header and will sort all the rows in red to the top based on the date it was delivered, same thing goes for date paid, date Collected, and overweight Fee. And to sort everything back to it's original position I click on the "bin #" header...is that possible?

good morning, im off work today.....ok so are you ready lol

alright here i go

So, the only time the row is replicated to the outstanding bins sheet is when a value is inputted in date collected column and if date paid column is blank from the main sheet.

if there is a value inputted in date paid column, then the row is not replicated when a value is inputted in date collected column

and the only time the row is replicated to the overweight bin sheet is when a value from the main sheet is inputted in overweight fee column

real world example

Customer calls and I input information for the day. When delivered the row turns red, this lets me know its a bin that hasn't been picked up

if paid the row turns green, which means the row doesn't need to be replicated. but if i dump the bin and is overweight, i input the value row changes blue and its replicated to the overweight bin sheet so i know to contact customer.

Now if the bin is collected and not paid for, I input the value, row changes to yellow, and is replicated to the outstanding bin sheet so I know to follow up with customers. And like before if overweight, row changes blue and is replicated to overweight bin sheet.

ok i hope that clarifies lol

Hey!!!.....Yes and it does need to be adjusted to copy exactly what's is in the row...

Quote from Carim

Hello again,

Attached is your test file ...to change the Row color without conditional formatting ...for your working sheets ...

Let me have your comments ...

Hope this will help

Display More

hey, busy day, just checked the file.....it work perfectly but...

ok let me try and explain

so the macro i had someone help me with, its function is to copy and auto populate the next available row in outstanding balances sheet only if date delivered and date collected is filled but not date paid, and for the overweight fee, if filled, it will auto fill the next available row in overweight sheet. So when i click on the outstanding balance sheet, the row will also be copied yellow from the main.

the file you sent me does exactly that except it copies the first color(red) used in the row from the main sheet, not the last color(yellow) if that makes sense. for example main sheet row will be yellow, but when auto copied, the row in overweight sheet will stay red not yellow......

hey i just want to say i appreciate all this, its been on my mind for 2 month!!

Quote from Carim

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.

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

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

Quote from Carim

Hello and Welcome to the Forum

Attached is your test file

Hope this will help

Display More

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

i believe its the order of my rules, because of that i cant override it if you get what i mean.

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.

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.