I'm using this formula in CF: =AND($AB64>=TODAY(),COUNTIF($AB$64:$AB64,">="&TODAY())=1) which works great to highlight the closest future date. Now, I need to add another condition into the formula, but I can't seem to work it out... Column (AA) shows "Cancelled" on certain dates and I want the above formula to skip those dates and instead highlight the next value with status Confirmed. See attached file for clarification.
Bookmarks