conditional formatting

L

Lisa

Thank you in advance for any help. I am trying to use conditional formatting
on a form and can not figure out the expression. I have dates in one column
and text in the next. I need the background to change in the date field based
on the text in the next column. i.e. column 1 / Received date {1/1/07},
column 2 / Received status {forecasted}. Because it is forecasted and late,
I need the background to change to yellow.
 
A

Arvin Meyer [MVP]

Set the combo box to:

Expression Is

then use an expression something like:

DateDiff("d",[Field1],[Field2])>5
 
Top