I thought I had this figured out but no...
Despite the excellent help from SSANFU, I'm still not able to get this to work. While I would like to upload a sample database, I keep getting an error and it's not able to upload.
I believe it was my fault for not being specifically clear...that I already had a database created and needed to add this option.
What I would like to have happen is this. Each person trained is evaluated and given a level (1 - 4) and is conditionally formatted based on the level given. However, management has asked if we could show last date trained and have that field formatted conditonally as well. For instance, if the last date trained was 8 weeks ago, the date field would be red, 6 weeks ago yellow, 4 weeks ago blue and 2 weeks ago green.
The reason I need the training levels to stay as they are is because our leads evaluate their workers as to what level they are at. Naturally, someone just learing the job would be a 1 (red) but his training record would be the current date (green). Conversely, an experienced employee could be a 4 (green) but the last time training was updated was over 8 weeks ago (red) so that would mean the employee needs have a refrehser on the task and the date would change to current (back to green).
I am not sure if this is merely a conditinal formatting issue or if coding is required. I would also need to have the same information appear in any form or report that is run.
I know I am asking the world on this but I am banging my head against the wall and am not getting any support from our IT department...this is too low on their priority list.
Thanks in advance to anyone who can help!