Color Fill in Cells

[tlc1680]

Hello, I am currently deployed in Iraq and am trying to create a database for tracking awards. I am trying to highlight all cells in my form whose status has been in one place for more than x days.
I can use conditional formatting to change the individual date cells but I am not sure how to get all cells in that record to turn green, yellow or red if one of the conditions is met.
Here is a short version of my table.
Fields: Name
Award
DTG to S-1
DTG to BDE
DTG to MNC-I
Status

If DTG to S-1 > 15 days from today fill all fields yellow
If DTG to S-1> 30 days from today fill all fields red
same for other locations

If Status = complete fill all cells green

Thanks for any help you can give let me know if you need more details

[MSeda]

you can write a condition based on the value of another contrl. choose "expression" on the conditional formatting window andjust enter the formula like text1 <= date() - 10.

[tlc1680]

Thanks that was too easy!!
Now my question is some fields such as unit and award type are based on another table and are a dropdown box in my form, which does not allow me to do conditional formatting, it doesnt even come up as an option. Is there a way to resolve this?

[MMcCarthy]

Thanks that was too easy!!
Now my question is some fields such as unit and award type are based on another table and are a dropdown box in my form, which does not allow me to do conditional formatting, it doesnt even come up as an option. Is there a way to resolve this?

The conditional formatting on a combo box shouldn't be a problem. It should be an option available. What are you trying to do?

[tlc1680]

For some reason conditional formatting isnt even an option for me when I right click oncertain cells such as rank.

[MMcCarthy]

For some reason conditional formatting isnt even an option for me when I right click oncertain cells such as rank.

What is the control type of rank?
What is the control source set to?
What is the datatype and format of this control?