Results 1 to 4 of 4
  1. #1
    assi11 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    7

    Date Formula in Conditional Formatting

    Hello,

    I have a list of employees attending various events.


    I have a table of event assignments. What I need is a formula in the cell of the event start date.
    Once I choose an employee, I want to verify that this employee is not already assigned within 10 day before and after the selected date.
    If already assigned within this period, the cell should change color. Can anyone can assist?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    did you try Conditional formatting?

    in the query , make a field :
    IsAssigned: [assignedDate] between DateAdd("d",-10,([assignedDate] ) and DateAdd("d",10,([assignedDate] )
    set conditional formatting If True, color = Yellow

    (pick your color)

  3. #3
    assi11 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    7
    Quote Originally Posted by ranman256 View Post
    did you try Conditional formatting?

    in the query , make a field :
    IsAssigned: [assignedDate] between DateAdd("d",-10,([assignedDate] ) and DateAdd("d",10,([assignedDate] )
    set conditional formatting If True, color = Yellow

    (pick your color)
    Thanks Ranman,
    Thanks for reply.
    I see no indication about the employee. I have a field "EmployeeName" (which I select from a drop-down list), and a field of "StartDate" (already filled-in).
    I need the "Startdate" to change the color if the specific employee I select is already engaged...

  4. #4
    assi11 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    7
    Hello,
    Could anyone help?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 04-20-2015, 05:54 AM
  2. Conditional Formatting For a Specific Date
    By RangerE51 in forum Access
    Replies: 2
    Last Post: 02-13-2015, 12:22 AM
  3. Replies: 4
    Last Post: 01-31-2014, 06:57 PM
  4. Date Conditional Formatting
    By f15avionics in forum Access
    Replies: 3
    Last Post: 09-21-2012, 04:45 AM
  5. Conditional Formatting date due color
    By Desstro in forum Programming
    Replies: 1
    Last Post: 12-08-2010, 11:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums