Need to have a date range that changes color

CAGELEE

New Member
Joined
Jun 2, 2018
Messages
1
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!
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,246
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,532
Messages
5,529,393
Members
409,870
Latest member
Well59
Top