Conditional Formatting

[dualhcsniatpac]

I need some help in vba coding.

What I am shooting for is that if the date is a saturday or sunday it turns the text red. I am submitting info on a form to another file. I figured there are 2 ways. To all at once format the whole row (Which will be dates: 03/17/2009) or to format the data at the time of insertion. I do not know which one would be faster to process.

What I have for the row editing so far is Columns("A:A,W:W").???????

Sorry if I left any needed info out.

Thanks,
David

 

[SteveO59L]

Use the weekday() function, something like =if(weekday(a1)>5)=true

 

[dualhcsniatpac]

I appreciate the reply but I am not working with the actual sheet. I am using VBA. The weekday function looks like something that I should use. I will try to work with that. Still looking for guidance though!

 

[SteveO59L]

Why do you want to use VBA ?, when there is a perfectly good built-in function ?

 

[dualhcsniatpac]

The way my program is set up is I have 1 excel file that has a form only. The info is dumped into a file that is created based on date (Along with the sheets too, which are created for every month of the year). By doing this, I need to use VBA.

Ex. Jan 1 a new file is created for 2009 with 1 sheet named January. Feb 1, a new sheet is created (by vba) named February, and so on. This is done because this tool will not get utilized if it is user dependent to create files so they need to be created automatically.

Not sure if I explained that well.