thanks went CF option

--
Regards

Corey

"Halim" wrote in message
...
hi corey,

Better you use Conditional formating :
FormatConditional Formatting...


Excel will choose your criterion..

Thanks.

Halim


"Corey" wrote:

How would i do this via code:

If "A1"="" then "A2" font Colour="White"
else "A2" font colour="Blue"

I want to do this to a range of cells from A1:A48



Regards

Corey