help with conditional formating in EXCEL

Reply #17

phileight — Thu, 05 Mar 2009 13:27:31 GMT

The colon thing is good to know. the if statement is just too easy. as rigid as other statement are I would not have tried this.

its these little things that people leave out or don't mention when trying to show how to do something. I've looked at several web sites trying to figure things out for myself, no mention of this.

thanks and I'll try not to bother you too much.

p8

Reply #16

time*treat — Thu, 05 Mar 2009 11:46:15 GMT

If you have a special reason for using GoTo done , you will need a line somewhere called done: Probably right over an End Sub statement.

Yes, the : is required.

If you aren't going to do some last minute thing before ending the code run, why not use If c2 9 Then End

Reply #15

phileight — Thu, 05 Mar 2009 01:39:58 GMT

time*treat

I feel that i'm making progress till i hit a wall. this code does what i want it to. question is how to terminate and shut it down you can see my intent was to enter a # larger than 9 as my trigger. what i'm trying doesnot work and i have been unable to find an example to guide me. thaks for your help and patience.

Sub color()

test = True

Call clear_color

Do While test = True

Call set_guess

Call clear_color

Call set_color

If test = False Then Exit Su... [ More ]

Reply #14

time*treat — Wed, 04 Mar 2009 12:31:13 GMT

The inertia of using what I already know has kept me from learning newer languages, even though I have bought books on them.

The old code still works. Even though I'm using a newer version of Excel, I'm still using VBA books I bought several years ago.

Reply #13

phileight — Wed, 04 Mar 2009 11:50:50 GMT

I did try this and a dozen variations yesterday, i did have another issue going on code break finally figured that out using the help file.

thanks for your help. for now keeping it simple is where i need to be untill i understand the basics.

p8

Reply #12

time*treat — Wed, 04 Mar 2009 03:18:31 GMT

how do i get this to loop until i'm done instead of having to restart it each time?

You'd have to set some condition and check it periodically; usually another loop. How do you know when you're done?

how do i call a subroutine from within this code?

If you are NOT going to pass any info (values) from one to the other ....

sub marco()

'do stuff'

polo

'back from polo to do some other stuff'

end sub

sub polo()

'arrive from marco to do stuff over here... [ More ]

Reply #11

phileight — Wed, 04 Mar 2009 02:06:52 GMT

RJOH

perhaps it's lack of knowledge on my part but the computers i have tried with xp and vista would not support the lower resolution needed to view gwbasic. the display is so poor i can barely read it. it is forceing me to move on before my old computer dies. maybe thats a good thing. learning something new keeps the brain cells working, as I get older they need all the exercise I can give them.

time*treat or anyone who would like to jump in, i used okay modified your input code and i ha... [ More ]

Reply #10

RJOh — Tue, 03 Mar 2009 23:29:53 GMT

I too bought Quick Basic and Visual Basic intending to learn them and never learned either well enough to write a program. It has just been too easy to keep using GWBasic since newer versions of Window had a command window that supported DOS type programs. I never moved up to Vista but I haven't had any trouble running my programs with XP and I hope Window 7 will do the same as I don't plan to upgrade my computer until the next version of Windows comes out.

I'm also surprised to see the lates... [ More ]

Reply #9

phileight — Tue, 03 Mar 2009 22:45:42 GMT

time treat thanks i believe another light just came on. i'm sure I will have more questions as I progress.

RJOH I enjoy Gwbasic and would prefer to continue using it. XP and Vista barely support it. I have found i have to use Gwbasic to create output files that I then inport to excel so I can see them. I have bought a couple of books on VB just have never been able(maybe willing) to get started. this year my goal is to learn enough VB VBA to convert what I consider my useful GWBasic file... [ More ]

Reply #8

RJOh — Tue, 03 Mar 2009 17:12:48 GMT

If you understand GWBasic, why not use it to write an application to do what you want? I've written all my lottery applications using it and complied them using a Quick Basic complier which allows the programs to be larger.

Reply #7

time*treat — Tue, 03 Mar 2009 17:01:04 GMT

Sub input_box_example()

'by time*treat'

Dim var_name As Integer

var_name = Application.InputBox( Prompt goes here , box title goes here , Type:=1)

'type = 1, for integers'

Cells(1, 1).Value = var_name

End Sub

Using f8 key to step throuth this one will show you how it works. The type:=1 statement adds a bit of idiot-proofing so that if you enter a letter then it will prompt you to try again. If you enter 123, then the value of var_name becomes 123.... [ More ]

Reply #6

phileight — Tue, 03 Mar 2009 14:06:51 GMT

time*treat

thanks. That was one of those duh moments, hour or so after i posted the question it occured to me to use a loop with incremented # to find the answer, something i've done for years in gwbasic.

I could use help with syntax for a user input. the equivalent to gwbasic input whatever ;x$

computer provides a prompt and waits for you to hit enter key.

even simple things are difficult when you don't understand them.

thanks

p8

Reply #5

time*treat — Tue, 03 Mar 2009 06:13:29 GMT

Interior.ColorIndex = 0

Reply #4

phileight — Tue, 03 Mar 2009 02:01:18 GMT

gasmeterguy

thanks for the help. i have a working file. a couple of questions if I may. once i run this various cells are colored in just as i want. what code returns them to original color or default background. i can create another loop to clear if i knew what color # to use. you said create button to start this. I have no clue where to start. i will include the code i have. again thanks.

Public Sub COLOR()

For X = 4 To 30' ROW 4 THRU 30

For Y = 2 To 5 ' COL BCDE

If Cells(2,... [ More ]

Reply #3

GASMETERGUY — Mon, 02 Mar 2009 01:17:42 GMT

Go to my blog. I have some information about

Excel there; how to get to VBA; how to start a program.

Now I am a rank amatuer when it comes to VBA programming. There are others on this site that have much more expertise than I. I know what I want and how to get there. It ain't pretty but it works and that is all I care about.

Perhaps a professional will step in and guide you. Until then, I will keep an eye on this thread.

Reply #2

phileight — Sun, 01 Mar 2009 02:43:21 GMT

Gasmeterguy

thanks for the help. I follow the logic and with the syntax i think i can do this part. how to start the program still eludes me.

my basic idea is to place my guess in say a1,b1,c1,d1 then use a for next loop for say last 50 games to see the patterns that the numbers in the target comb form in past draws. the winning number is frequently in a one touch pattern often several times, but difficult to see.

thanks

p8

Reply #1

GASMETERGUY — Sun, 01 Mar 2009 01:30:08 GMT

try something like this

if cells(row,column) = cells(row,column) then cells(row,column).interior.colorindex = 3

This code must be placed inside a VBA module. Then you can run the code either from the Tools-Macro button from the tool bar or create a run button labeled Run me or Run This or whatever.

help with conditional formating in EXCEL

phileight — Thu, 26 Feb 2009 23:56:18 GMT

A B C D

1

2

3

4

1

7

5

5

1

4

3

3

3

2

0

9

5

7

2

1

I need some help with conditional formatting. 3 conditions I can do. I want 4. Given the data above the 1 2 3 4 is the test condition, the other # s are the data to be tested. I can t get the row # s to show up correctly. If row 3 col A is = to row 1 col A or B or C or D set font color red , If row 3 colB is... [ More ]