excel formula help

Reply #13

lottaloot — Tue, 10 Jan 2006 00:25:57 GMT

You're a genius Time-Treat

Reply #12

lottaloot — Tue, 10 Jan 2006 00:15:26 GMT

Thanks a bunch. :=) Never an overkill when dealing with my money the lottery

Reply #11

time*treat — Mon, 09 Jan 2006 19:44:42 GMT

step 1) make a file called P3color.xlsstep 2) name a tab Main step 3) make sure Main is the active sheetstep 4) C P, then run this'------------------' Sub sheet__build() 'colors doubles triples' 'from 000 - 999' Dim M As Object Set M = Workbooks( P3Color.xls ).Sheets( Main ) Dim row As Integer, col As Integer Dim x As Integer, y As Integer Dim num As Integer Const light__green As Integer = 35 Const light__blue A... [ More ]

Reply #10

hareless — Mon, 09 Jan 2006 11:45:54 GMT

oh, what hyper said

Reply #9

hareless — Mon, 09 Jan 2006 11:44:25 GMT

oh, well, I got it to work for me. I highlighted column by itself and then conditioned it by saying if equal to the other 2 columns as 2 seperate conditions.then I took out the $ sign between the number and the letter and choose the backgroundworks like a charm

Reply #8

lottaloot — Mon, 09 Jan 2006 11:11:56 GMT

At the moment, it works enough for it to be correct. Working on 3 hrs of sleep here have to go in for another 12hr shift. Had a mother of a shift last night--(not breaking pt confidentiality) Had the pt reported on yesterday's news at Grace Hospital (supposedly he shot a cop who shot him). Worked non-stop without breakfast or lunch (and very minimal LP time ) for literally 11hrs straight on my feet another 1hr for paperwork. And I get to do it all over again today BUT I WILL get my LP... [ More ]

Reply #7

lottaloot — Mon, 09 Jan 2006 10:58:22 GMT

Thanks Hyper. I'll try this out tonight.

Reply #6

hypersoniq — Mon, 09 Jan 2006 10:49:52 GMT

let's take the first number only.. 066assume it starts in A1, soA1=0B1=6C1=6conditional formats (by cell)A1conditional format 1 if cell value is equal to B1 conditional format 2 if cell value is equal to C1 B1conditional format 1 if cell value is equal to A1 conditional format 2 if cell value is equal to C1 C1conditional format 1 if cell value is equal to A1 conditional format 2 if cell value is equal to B1 to keep the relative addressing select all 3 cells when painting the format to D1/E... [ More ]

Reply #5

lottaloot — Mon, 09 Jan 2006 10:05:27 GMT

I do not think you can use a conditional format with that many doubles. I have them listed as above in one sheet separated in another.

Reply #4

hareless — Mon, 09 Jan 2006 09:54:33 GMT

you are going to have to seperate them in seperate cells and then use conditional formating

Reply #3

lottaloot — Mon, 09 Jan 2006 03:28:51 GMT

Whatever way is quickest easiest. Didn't know twhere to start at using a macro.

Reply #2

time*treat — Sun, 08 Jan 2006 22:02:29 GMT

Are you looking for a spreadsheet formula or macro

Reply #1

hypersoniq — Sun, 08 Jan 2006 05:03:52 GMT

I thought it would be easy to do with conditional formatting, but I am having a tough time with it... tried using right(cell,index) (example Right(A1,1)=Right(A1,2)) but no luck...you may need to put wach digit in a separate cell... I'll keep trying tho...gotta sleep now, however

excel formula help

lottaloot — Sun, 08 Jan 2006 04:32:54 GMT

I am looking for a formula that will highlight all the double digit combos that have listed below. 066336227557508734116735284879486389622139981094909371683244250134015317912093870790 Don't know if I would need a vlookup here or if it has to be set up in another format.Any help is appreciated