Changing font color in one cell only

B

Barbara

I am trying to change the color of one cell in a
table/database to call attention that the date is
expired. It is the only cell in the field that needs to
have color.
 
M

Mark

If you create a Form based on the table, you can change
as many individual cells as you like.
 
B

Brad Allison

Go into the form design and select Conditional formatting from the Format
menu. I have a date field in which if the item was received into our office
sixty days after the purchase date, this item is expired and I want that
field to change to BOLD RED. In Conditional formatting, I use this formula:
[Date]+60.

Hope this helps.

Brad
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top