Oct 2, 2002 #1 isorders IS-IT--Management Dec 6, 2001 102 US I am setting up a schedule notification form and I want all of the dates that are older than the current date to appear in red. Any ideas? Thanks
I am setting up a schedule notification form and I want all of the dates that are older than the current date to appear in red. Any ideas? Thanks
Oct 2, 2002 1 #2 LittleSmudge Programmer Mar 18, 2002 2,848 GB In design view - click on the control, then go to Format menu - Conditional Formatting. In there you can set the colour / bold etc of the text based on the value that is in the cell. 'ope-that-'elps. G LS Upvote 0 Downvote
In design view - click on the control, then go to Format menu - Conditional Formatting. In there you can set the colour / bold etc of the text based on the value that is in the cell. 'ope-that-'elps. G LS