Pls Need Help with Conditional formatting

[TotallyConfused]

I need help on setting a conditional formatting to a control in a form. I
want this date field_2 to look another date field_1. If date field 1 is
greater by 7 days than date field 2 than "BOLD" and "red". Can this be done?
I tried setting this but it will not do anything. I hope you can help me
with this. thank you in advance for any help you can provide.

 

[fredg]

I need help on setting a conditional formatting to a control in a form. I
want this date field_2 to look another date field_1. If date field 1 is
greater by 7 days than date field 2 than "BOLD" and "red". Can this be done?
I tried setting this but it will not do anything. I hope you can help me
with this. thank you in advance for any help you can provide.

Set teh condition1 to
Expression Is
Set the expression to:
[Date1]-[Date2]>=7

Set your font color and bold as wanted.

 

[TotallyConfused]

Thank you very much. However, I need to work with only workdays. Do I need
to specify workdays? If so how? Thank you

I need help on setting a conditional formatting to a control in a form. I
want this date field_2 to look another date field_1. If date field 1 is
greater by 7 days than date field 2 than "BOLD" and "red". Can this be done?
I tried setting this but it will not do anything. I hope you can help me
with this. thank you in advance for any help you can provide.

Set teh condition1 to
Expression Is
Set the expression to:
[Date1]-[Date2]>=7

Set your font color and bold as wanted.

 

[Jacqueline]

Here is a link to a MS training that gives you formula for calculateing work
days:

http://office.microsoft.com/en-us/assistance/HA010550781033.aspx

--
Jacqueline

Thank you very much. However, I need to work with only workdays. Do I need
to specify workdays? If so how? Thank you

I need help on setting a conditional formatting to a control in a form. I
want this date field_2 to look another date field_1. If date field 1 is
greater by 7 days than date field 2 than "BOLD" and "red". Can this be done?
I tried setting this but it will not do anything. I hope you can help me
with this. thank you in advance for any help you can provide.

Set teh condition1 to
Expression Is
Set the expression to:
[Date1]-[Date2]>=7

Set your font color and bold as wanted.