Conditional Formating Issue

A

adam

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.
 
J

Joel

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.
 
R

Rick Rothstein \(MVP - VB\)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top