Conditional formatting with VB

works like a champ! =) only question is.. now, how do i input multiple vb coding into the same sheet?

for example, i have a code that makes all text in caps. how do i have both? im sure there is a simple solution.

ok, i figured it out! thanks again for all the help.

The code I posted does both, right?

sorry for the late reply, the code worked great! thanks again =)

You're welcome, I was just wondering if I'd missed something.