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...
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.
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.
- That worked, thank you. Is there a way to change the text color green also so that the past due number of days doesn't show when the cell turns green.
Yes - select the range, then click Conditional Formatting > Manage Rules...
Select the rule for green, and click Edit.
Click Format...
Activate the Font tab, and select the same font color that you used in the Fill tab.
Then OK your way out.
