Have a field change color based on date of another field

[Ian Frost]

How do I have fields change color based on the date of another field?

My Example:
Site Visited - 7/5/16
IRP Comments Due(15 days) - Projected date to submit comments by 7/20/16
Corps Comments Due (30 days) - Projected date to submit comments by 8/4/16

Based on the Site Visited - 7/5/16, I would like to have the IRP comments cell highlighted green until it reaches 10 days, after 10 days the cell would then highlight to yellow and after 15 days the cell would highlight red. For Corps comments the cell would be highlighted in green until it reaches 25 days past the original site visit, then it would turn yellow. After 30 days it would turn red.

[Richard Buttrey]

Hi,

Have you tried conditional formats?

Please explain what you mean by 'it reaches 10 days'. What's "It"? Is that the date to submit comments, the current date or what?

It's always easier if you can upload an example workbook so that we can see in context. Manually add the colours you expect to see.

[FDibbins]

You would do this with Conditional Formatting...
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =A1<=today()-10
change A1 to suite

Repeat 3 and 4 for >10