I would like to create a color condition green, red, yellow using the following conditions but having problems with the formula.
Details:
I want the color change to take place in column A base on the following:
1. "Green" - display green IF current date Now() is LESS THAN the start date (col F)
2. "Green" - display Green IF % complete (col C) is 100%
3. "Yellow" - display yellow IF current date NOW () is GREATER THAN OR EQUAL TO the start date (col F) AND % complete (col C) is less than 100%
4. "Red" - display red IF current date NOW () is GREATER THAN OR EQUAL TO the finish date (col H) AND % complete is LESS THAN 100%.
Please with writing the formula for these conditions.
ThaNK YOU IN advance
Bookmarks