Pls Need Help with Conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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

Set your font color and bold as wanted.
 
Thank you very much. However, I need to work with only workdays. Do I need
to specify workdays? If so how? Thank you

fredg said:
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.
Click to expand...

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

Set your font color and bold as wanted.
Click to expand...
 
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


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

fredg said:
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.
Click to expand...

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

Set your font color and bold as wanted.
Click to expand...
Click to expand...
 
Back
Top