Need to have a date range that changes color

[CAGELEE]

Hi all!

New and would like to get some info. My boss wants me to have a column on an excel sheet for date ranges. In this column, each cell (working independently) needs to be able to respond to two different cells. By this, I mean:
Column F Origination Date
Column G Target Date
Column H Closed Date

I need to have the Target Date go green if more than 5 days from Origination Date. Yellow if Target is 0 - 5 within Origination Date. Red if Target is at or past Origination Date.

Thanks in advance!

 

[JoeMo]

Have a look at conditional formatting in Excel Help. Conditionally format the cells in col G that hold dates based on the how the col G dates compare to their counterpart dates in col F.