Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem using Conditional Formatting in Excel 2000
Trying to use Conditional Formatting in Excel 2000 to have the shading change and the contents of another cell copied into the cell in question. Example cell in question is F2 conditional format formula is =IF(AND(F$1>=$C2,F$1<=$D2),$E2, "") F1 = 1/1/2001 C2 = 1/1/2001 D2 =...- MisterBob
- Thread
- Replies: 4
- Forum: Microsoft: Office
-
How to have Excel run my saved query automatically?
I have used the query wizard in Excel to setup a query to get the data I want from Access and have saved the query. The data comes into the worksheet nicely. I use ShellExecute to start Excel and load the spreadsheet from within an Access Form using a command button. I need help on a few...- MisterBob
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
