Excel SQL 2000 Query

Ziycon · 2008-05-26 10:58:55

**Can a mod move this to programming, clicked on the wrong board sorry! I have an excel document and im using MS Query to query a MS SQL 2000 DB, im trying to use conditional formating within Excel but for some reason i it wont take affect on the cells that are getting data from the DB but the conditional formating will…

26-05-2008 10:58AM

#1

Ziycon

Registered Users, Registered Users 2 Posts: 1,991 ✭✭✭

Join Date: December 2004

Posts: 1618

**Can a mod move this to programming, clicked on the wrong board sorry!

I have an excel document and im using MS Query to query a MS SQL 2000 DB, im trying to use conditional formating within Excel but for some reason i it wont take affect on the cells that are getting data from the DB but the conditional formating will work on cells that are not coming from the DB!?

0

Comments

#2 26-05-2008 07:05PM

FSL

Registered Users, Registered Users 2 Posts: 1,456 ✭✭✭

Join Date: February 2006

Posts: 1419

May be MS Query reformats the cells when it imports the data. Try putting the data into a different sheet and have the formatted cells reference the imported data.

0