Conditonal Formatting is what you need. It can be applied from either the
worksheet or VBA.
See:
http://www.contextures.com/xlCondFormat01.html
--
Gary's Student
"geetha.chintalapudi[ at ]gmail.com" wrote:
[Quoted Text] > I want to populate data into excel sheet from sql db which I have
> already done. But I want to populate the data in different colors
> depending on one columen value...for eg..in col3 the values are
> ERROR,INFO etc....if the value is ERROR the records should come in red.
> If it is INFO the records should be in white..otherwise in Green
> color...
>
> Please let me know how to do this...
>
>
|