need formula/notification help...looking for a cell to become highlighted or otherwise notified when a schedule/ETA has arrived/expired. is that even possible?
Tags:
Conditional formatting.
Select the cells with dates, go into the conditonal formatting dialogue, set to if less than "=today()"
Dunno how your dialogue looks like, I run an old version of XL, but for example, if you want to highlight an expired time, for example you:
1) Select the field of dates and times you want to check.
2) Go into the CF dialogue.
3) Select "Cell Value is" + "less than" + either "=now()" or "=today()" or a cell containing the current time/date. I don't know how you are keeping your dates/times formatted, I know little abotu how excel does this.
4) Select the "format" button, then set the format you want (e.g. make the background of the cell red)
do i need to do that per cell or can assign to spreadsheet?
envane x said:Dunno how your dialogue looks like, I run an old version of XL, but for example, if you want to highlight an expired time, for example you:
1) Select the field of dates and times you want to check.
2) Go into the CF dialogue.
3) Select "Cell Value is" + "less than" + either "=now()" or "=today()" or a cell containing the current time/date. I don't know how you are keeping your dates/times formatted, I know little abotu how excel does this.
4) Select the "format" button, then set the format you want (e.g. make the background of the cell red)
262 members
203 members
269 members
63 members
172 members