 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / May 2008Conditional Formating Issue
Im querying a SQL 2000 DB and trying to use conditional formatting on the fields that the data from the DB is in to change the background colour. The conditional formating wont work on the fields with the DB data but it works fine on other fields!? Im using Excel 2003 and MSSQL 2000 Enterprise. The data is probably in the wrong format. either a string instead of a number, or a number instead ofr a string. Highlight one of the cells with the problem and check the format by going to the menu Format - Cells - Number a see what the format is. Also number can be changed to text by putting a single quote in front of the number. You may need to remove the single quote. > Im querying a SQL 2000 DB and trying to use conditional formatting on the > fields that the data from the DB is in to change the background colour. The > conditional formating wont work on the fields with the DB data but it works > fine on other fields!? > Im using Excel 2003 and MSSQL 2000 Enterprise. Tried all you suggested, nothing, still the same!? > The data is probably in the wrong format. either a string instead of a > number, or a number instead ofr a string. Highlight one of the cells with [quoted text clipped - 7 lines] > > fine on other fields!? > > Im using Excel 2003 and MSSQL 2000 Enterprise. Another possibility is that your data is coming over with leading or trailing spaces. If that turns out not to be the case, then perhaps if you post your Conditional Format function for us to see, it might give us a clue as to what could be going wrong. Rick > Tried all you suggested, nothing, still the same!? > [quoted text clipped - 16 lines] >> > fine on other fields!? >> > Im using Excel 2003 and MSSQL 2000 Enterprise. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.