View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NDBC NDBC is offline
external usenet poster
 
Posts: 204
Default Text format - setting text colour with code

I'm on the home straight now (I think). What I would like to do is make text
in a text box go red if a certain condition is met. ie.

If rider1.value 700 Then

rider1.font = colour red (or whatever the correct code for this is)

Thanks