brandonmcg
New Member
- Joined
- Jan 14, 2009
- Messages
- 43
- Office Version
- 2016
- Platform
- Windows
This is a project tracking spreadsheet.
There are hundreds of rows on this spreadsheet all starting row 2 of each column
Headers
Column F1 Actual Start Date
Column G1 Expected Completion Date
Column H1 Days Until Due
Column i1 Actual Completion Date
I am looking for a three tier color code combination
If i is not populated then in the i cell color code
If H1 15 Days or greater green
If H1 between 8 to 14 days yellow
If H1 is any negative number to 7 days red
If i1 is populated then no color. If this is too tricky then I can create a new column to house the color codes.
If i is populated with a date how do I not have a number in column H and no color?
There are hundreds of rows on this spreadsheet all starting row 2 of each column
Headers
Column F1 Actual Start Date
Column G1 Expected Completion Date
Column H1 Days Until Due
Column i1 Actual Completion Date
I am looking for a three tier color code combination
If i is not populated then in the i cell color code
If H1 15 Days or greater green
If H1 between 8 to 14 days yellow
If H1 is any negative number to 7 days red
If i1 is populated then no color. If this is too tricky then I can create a new column to house the color codes.
If i is populated with a date how do I not have a number in column H and no color?