How to conditional format Excel 2010 to trigger flag icon in new column, based on due dates

Question

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)

Answer 1

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 ;;;.

Answer 2

The red flag seems to be available only in the cell you are trying to format, not in an adjacent cell.

You can try that.

Select your deadline row.

Add a Conditional Formatting

Format all cells based on their values Select Icon Sets in Format Style Select 3 Flags in Icon Style Tick Reverse the Icon Order On the red flag select > enter =today() in value and Formula in type On the orange flag select > enter =today() in value and Formula in type

You will end up with a red flag in the deadline cell if the date > today. But unfortunately a green flag if date <= today.