CODEWITHSUNDEEP
excelexcel-2010
RCoy1978
RCoy1978

Reputation: 125

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

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)

Upvotes: 5

Views: 78984

Answers (2)

Doug Glancy
Doug Glancy

Reputation: 27478

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.

enter image description here

3rd: Custom format in cells to hide 1's and 0's. The format is ;;;.

enter image description here

Upvotes: 7

baptme
baptme

Reputation: 10092

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.

Upvotes: 1

Related Questions