Format > ConditionalFormat > and follow the menus..........

Vaya con Dios,
Chuck, CABGx3



"CORY" wrote:

> can i set up a formula so that if there is no value for a certian cell, then
> another cell shows up highlighted red??