Make cell color depend on cell data

[manju.msrit]

hi
i am new to this forum, i am not able to post questions,


how to color a cell in atable with different colors , the color is decided based upon cell data, that is if data = met then color is green if not some other color,
i know that i am disturbing u , sorry for the inconvience


Regards
akash

[martinlim]

Haha, I am also newbie in the forum. If using VB 6.0, then I know lar. Wat coding you are doing?