In the attached file, I’m trying to utilize conditional formatting and the traffic light color coding for: FCST dates out over seven days (White), FCST dates past due (RED), FCST dates within seven days out (YELLOW) and actuals where FCST and ACT are both date populated (GREEN). I can’t seem to figure out the formula to make the actuals green where a date is populated for both the FCST and ACT columns for all tasks. The formula I’m using for the green color coding is not working because I’m sure it’s not correct. Any help you could provide would be appreciated.Here's a file where the conditional formatting starts to fall apart for actuals around columns AX/AY where the FCST columns are green and the ACT columns red.
Bookmarks