If >2 "Change # format Red"


Posted by Jim on June 21, 2001 9:02 AM

I have a commandbutton_Click()that copies and paste
a range,what i would like to happen is if any of the
numbers are greater than 2 after the copy and paste
occurs it would turn the number(s)greater than 2 red
Thanks, Jim



Posted by Mark W. on June 21, 2001 9:06 AM

Consider apply a custom number format using...

[Red][>2]General;General