Conditional Formatting Question

J

JamesJ

I've a continuous form with 3 fields the row. One is a Date field.
How can I set all 3 field's text color to red if the Date field equals
Date()??
I can set the format for the Date field but I would like the other 2 fields
to
have the text red, also.

Any help will be appreciated,
James
 
P

Peter Hibbs

James,

You asked the same question yesterday and got two replies. Did you not
see those or did they not work for you.

Peter.
 
F

fredg

I've a continuous form with 3 fields the row. One is a Date field.
How can I set all 3 field's text color to red if the Date field equals
Date()??
I can set the format for the Date field but I would like the other 2 fields
to
have the text red, also.

Any help will be appreciated,
James
Click to expand...

Turn red only if the date field equals the date? Not before nor
after?

Select the Date field.
Click on Format + Conditional Formatting.
Set Condition1 to:
FieldValue Is
Select
equal to
Enter
Date()
in the next box.

Select the Red color from the tool button list.
Save the changes.

Select the other 2 controls.
Go to Conditional Formatting as above.
For Condition1 select
Expression Is
Write
[DateFieldName] = Date()

Select the Red color.

Save the changes.
 
J

JamesJ

Works great! Thanks much.
Sorry 'bout posting twice but I don't 'see' my original post
in Windows Mail.

Thanks again,
James

fredg said:
I've a continuous form with 3 fields the row. One is a Date field.
How can I set all 3 field's text color to red if the Date field equals
Date()??
I can set the format for the Date field but I would like the other 2
fields
to
have the text red, also.

Any help will be appreciated,
James
Click to expand...

Turn red only if the date field equals the date? Not before nor
after?

Select the Date field.
Click on Format + Conditional Formatting.
Set Condition1 to:
FieldValue Is
Select
equal to
Enter
Date()
in the next box.

Select the Red color from the tool button list.
Save the changes.

Select the other 2 controls.
Go to Conditional Formatting as above.
For Condition1 select
Expression Is
Write
[DateFieldName] = Date()

Select the Red color.

Save the changes.
Click to expand...
 
Top