Changing font color in one cell only

  • Thread starter Thread starter Barbara
  • Start date Start date
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.
 
If you create a Form based on the table, you can change
as many individual cells as you like.
 
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
 
Back
Top