Hypersoniq or Anyone Excel Help

Reply #6

hypersoniq — Wed, 30 Jun 2004 08:21:06 GMT

anytime Sandy K.gl

Reply #5

Sandy K — Wed, 30 Jun 2004 01:12:35 GMT

Thank Hyper, you are always there when I need you. Thank you so much. I hope you win the big one some day.......you sure deserve it with all the help you give to so many people.

Reply #4

hypersoniq — Tue, 29 Jun 2004 23:06:16 GMT

ok, you don't need to copy and paste the conditional formatting... you just need to format paint it (the little paintbrush on the standard excel toolbar... Anchoring is wrong, your husband had that right.... take out the dollar signs.1. click the cell you have applied conditional formatting to2. click the paintbrush3. click and drag the cells above to smoothly and effortlessly copy the conditional formatting upward...4. repeat this for each position.good luck

Reply #3

Sandy K — Tue, 29 Jun 2004 12:57:42 GMT

Thank you wsls. I will try it and thanks for all your help.As far as Peter goes, geez......I struggle with excel as it is.............have no idea about a database.Again, thanks.

Reply #2

winsumloosesum — Tue, 29 Jun 2004 12:47:33 GMT

Sandy,Check your PM.Hope this will help you.wsls

Reply #1

Kp2o3 — Tue, 29 Jun 2004 12:06:43 GMT

Hello. Whay are you using a spreadsheet program. I think you should be using a Database program. What state are you in, and do you by any chance have the complete history file for the Pick-3 in that state?email me kp@gate.netTnx. Peter C. Stuart, FL

Hypersoniq or Anyone Excel Help

Sandy K — Tue, 29 Jun 2004 11:42:46 GMT

I am trudging along with my spreadsheet.........and I got a problem again....Example:yesterday's draw: 670 in cells D1,E1,F1today's draw: 175 in cells D2,E2,F2What I want to do is highlight the repeat number which is 7..............and I am having a dickens of a time...........I click on the cells in D2:F2, each individually.I can get to highlight alright with this formula:Conditional formatCell Value is equal to =D1Cell Value is equal to =E1Cell Value is equal to =F1Well, it d... [ More ]