Forum Discussion
Excel Help
Hello! I would like help in these issues, please: 1. I would like a cell to auto-populate based on information in another. For example: If cell C1 shows a date less than today, cell D1 will show “O...
The formula fin D1 would be:
=IF(C1<TODAY(),"Overdue","")
Note that this will also leave D! blank if C1 equals todays's date!
To set the color to red when overdue you could use almost the same as a rule for Conditional Formatting. Select, for instance A1:D100, and create a New Rule (on the Mac that is Home, Styles, Conditional Formatting, New Rule, Classic, Based on a formula......) like:
=$C1<TODAY()
or
=$D1="Overdue"
Set the Fill and Font color as desired. You can set the upper and lower border of all the cells and need two extra rules to set just the left bordet in column A and the right border in column D.
Attached an example file with a working example of the conditional format.
Just to clarify: There is no formula that can auto-populate data in an adjacent cell, i.e., If Column C is today or older, Column D will show "Overdue".
Thank you!
Thank you!