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

Conditional Formating Issue
 

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.

"adam" wrote:

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.

Conditional Formating Issue
 

Tried all you suggested, nothing, still the same!?

"Joel" wrote:

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.

"adam" wrote:

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.

Conditional Formating Issue
 

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


"adam" wrote in message
...
Tried all you suggested, nothing, still the same!?

"Joel" wrote:

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.

"adam" wrote:

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.