Thanks that helped me do what I wanted except that I want other text boxes to change color based as well based on the value of the original one. The other text box I want to change as well is called Meeting.
Thanks in advance
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)...