autoset cell fill colour

Originally Posted by andr3w266

Hello all

i've got an excel (2003) worksheet with data pulling from an SQL database. in one of the columns (D), the cells can only have 1 of 4 numerical values (1, 2, 3, 301).

when the data is refreshed, i want the cells in this column ONLY (column D) to change to a set colour depending on this numerical value.
so eg if the value in D1 is "1" the cell should be red, if in D2 its "301", the cell goes green etc.

I've tried some vb to do this, but it seems to consider values in all cells in the whole sheet(eg if there's a "3" in cell A7, it changes colour), and change colours of every cell, but i only want it to consider one column, with 4 values, and only fill the cells in that 1 column

any help would be great

using Conditional Formatting will solve your problem

try this link
http://www.contextures.com/xlCondFormat01.html

Conditional Formatting allow three conditions, however you can use any default colour as fourth option.

Originally Posted by andr3w266

thanks for the reply, i apprecite it.
And it is a correct answer to my question.
However, if i were to get more than 4 values (ie 1 default and 3 conditional) this wouldnt work, which is why i was trying to achieve this through VB rather than the conditional formatting options

ok try this link

http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm