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.