Conditional Formatting Formula

[jwakefield]

New to the forum....so thanks ahead of time.

The Issue:

Doing a spreadsheet that covers different tasks that need to be completed by a Target Date.

So there are 3 columns.....Task, Target Date, and Date Completed.

I'd like to format so that the cells turn Green, Yellow, Red based on the following:

Green: There is some date in the "Date Completed" column so we know the task is done

Yellow: It's within 2 days of the target date and there is nothing in the "Date Completed" column

Red: Today is equal to the Target Date or sometime past it, and there is no value in the "Date Completed" column so we know it has not been completed and needs attention

So I know how to conditional format using a formula, I'm just trying to figure out what the formulas should be....I assume there will be a set of 3 that applies to each row?

Apologies again for my ignorance and thanks again for the help,

Best,

J

[Bob Phillips]

Assuming Target Date is B2, Date Completed is C2

Green: =C2<>""
Yellow: =AND(B2>TODAY(),B2<=TODAY()+2)
Red: =B2<=TODAY()

[jwakefield]

Worked perfectly....

Any suggestions for copying this conditional formatting to multiple rows.....

I got it working on one row, but i need it to work with like 200 others.

Thanks again,

J

[jwakefield]

Also,

I highlighted the whole row when i started the formatting....but the Fill Color only applies to the A cell of that row....is there anyway that it can turn the whole row that color??

Thanks,

J

[Bob Phillips]

You neeed to apply that formula to all the cells to be coloured, but make sure you make the column in the cell reference absolute.