conditional format or macro and how? (ALMOST FINISHED with

keith · Mar 6th, 2002, 03:49 PM

I have a excel "List" - one column in the list is "Date". There are multiple records (rows) with the same value in the "date" field/cell. I need all rows that have the same date value to be the same fill color. Basically I need to color code records of like dates. (The entire rows, not just the date cells)

Jack in the UK · Mar 6th, 2002, 04:07 PM

Hi Keith

Erm wanna colour them rows subect to the date eh!

OK look conditional format can do this, but i guess you have billions of date, how nmany>

I have code that will do this if date in one col.. can edit to another col as we go.. does this help i ahe 25 conditions in VBA that colour rows red blue what ever, subject to a word like:
Jack = Blue
UK = Red
and so on....

Mar 6th, 2002, 04:16 PM

well right now there are not any dates in the list (I am developing a list with a userform entry for a project and this is the last thing I need to do) but yes, there could be many many different dates. I don't care if colors repeat themselves as long as the same color is not directly above or below a row with a different date. I have no way of knowing what info will be in any of the fields corresponding to the dates so saying the jack=red won't really work I don't think cause I dunno if or where "jack" will show up in the list.. I may not be understanding what you are askin me though..

Jack in the UK · Mar 6th, 2002, 04:25 PM

Hi

I really wanna help - ive lost the plot !

Can you mail the sheet on JackintheUK@hotmail.com

Remove comfidential stuff and unprotect passwords, ill try to add some code to kick the date bit to colour row .... might work might not! cant promise if billions of dates wizzing about... worth a try or not?

keith · Mar 6th, 2002, 04:40 PM

ok - sent THANKS

keith · Mar 6th, 2002, 05:59 PM

I think I figured out a workaround.. trying it now

keith · Mar 6th, 2002, 06:38 PM

Hey wanted to let you know I found a workaround so you could stop working on a solution for me (if you had even got to it yet)... I used teh conditional format and a <> formula to set borders It isn't exactly what I wanted but it will do..

Thanks for the help anyway!

Keith

Mar 6th, 2002, 04:07 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Keith Erm wanna colour them rows subect to the date eh! OK look conditional format can do this, but i guess you have billions of date, how nmany> I have code that will do this if date in one col.. can edit to another col as we go.. does this help i ahe 25 conditions in VBA that colour rows red blue what ever, subject to a word like: Jack = Blue UK = Red and so on.... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Mar 6th, 2002, 04:25 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi I really wanna help - ive lost the plot ! Can you mail the sheet on JackintheUK@hotmail.com Remove comfidential stuff and unprotect passwords, ill try to add some code to kick the date bit to colour row .... might work might not! cant promise if billions of dates wizzing about... worth a try or not? __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 03:49 PM	#1
keith Board Regular Join Date: Mar 2002 Posts: 88	I have a excel "List" - one column in the list is "Date". There are multiple records (rows) with the same value in the "date" field/cell. I need all rows that have the same date value to be the same fill color. Basically I need to color code records of like dates. (The entire rows, not just the date cells)

Mar 6th, 2002, 04:16 PM	#3
Guest Posts: n/a	well right now there are not any dates in the list (I am developing a list with a userform entry for a project and this is the last thing I need to do) but yes, there could be many many different dates. I don't care if colors repeat themselves as long as the same color is not directly above or below a row with a different date. I have no way of knowing what info will be in any of the fields corresponding to the dates so saying the jack=red won't really work I don't think cause I dunno if or where "jack" will show up in the list.. I may not be understanding what you are askin me though..

Mar 6th, 2002, 04:40 PM	#5
keith Board Regular Join Date: Mar 2002 Posts: 88	ok - sent THANKS

Mar 6th, 2002, 05:59 PM	#6
keith Board Regular Join Date: Mar 2002 Posts: 88	I think I figured out a workaround.. trying it now

Mar 6th, 2002, 06:38 PM	#7
keith Board Regular Join Date: Mar 2002 Posts: 88	Hey wanted to let you know I found a workaround so you could stop working on a solution for me (if you had even got to it yet)... I used teh conditional format and a <> formula to set borders It isn't exactly what I wanted but it will do.. Thanks for the help anyway! Keith