Conditional Formating Issue

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

 

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

 

[adam]

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

 

[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