Forum Discussion
Color a cell based off of a date and number of days until task is delinquent
My first time posting. Been using Excel for years at the basic level but not a need to produce a spreadsheet that utilizes the customization tools. So can't seem to get this to work using a fo...
You need to use conditional format, create three rules in as the same order bellow:
Select the cells in column G2:G10, from home tab --> styles-->conditional formatting --> Manage rules
From the windows click on new rule --> Use a formula to determine which cells to format --> write the first formula in the format values where this formula is true box, --> click on Format button and pick up the blue color, --> OK
=F2- TODAY()>60
=F2- TODAY()>0
=L2<>"Completed"
Regarding the third condition, it is not clear what you want
- Great, Thank you for the assistance.
I'm not much worried about the L column because it's a drop down list and I select the proper condition.
Thank you again for the input.- Ok, so one more question. If I were to select Complete from the L2 dropdown is there a way to color G2 green and leave the formula in the G2 cell?
You can create a new rule for G2:G10 the same way as before, with the formula
=L2="Completed"
and green as fill color.
