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 strongm 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
Many thanks, found the cure for the problem. I set the font color to be the same as the cell color for the cell normal formatting. Had cell F2 reference cell E2. When the formatting formula returns true it set the font color to dark blue and the cell shading to light blue. So if I can do it...- MisterBob
- Post #5
- Forum: Microsoft: Office
-
Problem using Conditional Formatting in Excel 2000
The equation is in cell F2!!! Thanks- MisterBob
- Post #3
- Forum: Microsoft: Office
-
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)
