How to conditional format Excel 2010 to trigger flag icon in new column, based on due dates
excel, excel-2010
Solution
I did it like this:
1st: Added a formula to the Flag column: `=IF(A2>TODAY(),1,0)` 2nd: Conditional formatted flags as show in picture.
3rd: Custom format in cells to hide 1's and 0's. The format is `;;;`.
Problem
I have a row of deadline dates, I'm looking to flag with icon if deadline is past due date. Is there a way to use conditional formatting to trigger icons? The if then statement should be: If Today() > "Deadline" then flag cell in column 2 with red flag icon. Column 1 Deadline Column 2 (Red Flag if past due date)