Trying to get Excel to highlight cells based on assigned dates.

Hi

You have an absolute reference to $E$3 in your formatting test. Try removing the absolute as applied to the row and see how you go ($E3)

rylo

I changed it to $E3 versus $E$3, but no luck.

Project Tracking.xlsx

so the task 1 in column e is the due date and the actual in column f is the actual right? then you would highlight the cells in column f and do conditional formatting using a formula to determine: =AND(F3<=E3,F3<>"") meaning if the actual is earlier or equal to the task 1 (due date) and if actual is not blank then highlight green. BTW you don't have any that are after to highlight red, however you would add a new rule and do =AND(F3>E3,F3<>"") to highlight red.

if you select all of the cells that you want to do condidional formatting on then make the upper left cell the active cell you can do it all in one go.

Originally Posted by tatumrae

I changed it to $E3 versus $E$3, but no luck.

Sorry I didn't look at the other cells before I responded. This did fix my issue! Thank you!

In your conditional formatting remove all the dollar signs.

attached is the corrected file in case you want to see how I would do it.

Originally Posted by scott.s.fower

Attachment 227241

so the task 1 in column e is the due date and the actual in column f is the actual right? then you would highlight the cells in column f and do conditional formatting using a formula to determine: =AND(F3<=E3,F3<>"") meaning if the actual is earlier or equal to the task 1 (due date) and if actual is not blank then highlight green. BTW you don't have any that are after to highlight red, however you would add a new rule and do =AND(F3>E3,F3<>"") to highlight red.

if you select all of the cells that you want to do condidional formatting on then make the upper left cell the active cell you can do it all in one go.

Thank you so much! I was able to figure it out. I really appreciate the help!

Originally Posted by jleonard5106

In your conditional formatting remove all the dollar signs.

attached is the corrected file in case you want to see how I would do it.

Thank you as well! Your example was EXACTLY what I needed!