Comments
-
保罗,我to get it working with your code working for some reason it copied a period where the greater than symbol was suppost to be. Thank you as always, Caroline
-
Not working I have tried the blank this way multiple times and it does not work [Due Date]@row = "" I have always had to sue the ISBLANK funtion but not sure how to add to this code, no matter what I do not working
-
So that should be the last item on the list?
-
Paul, This is good, but can you tell me how to add one more item to this code If the due date is blank it needs to be green Where would I add this? =IF(Status@row <> "Complete", IF([Due Date]@row< TODAY(), "Red", IF([Due Date]@row>= TODAY(3), "Green", "Yellow")) Caroline
-
found one
-
now it seems to be working in all sheets, what would cause this? UGH! This code has been here for weeks and all of a suddent it was setting everything to complete? Now all of a sudden it has fixed itself.
-
Hi Paul. anything less than today should be red anything today tomorrow and the next day yellow so today+2 days anything 3+ days should be green Caroline
-
here you go
-
Don't want to add a bunch more columns just to get a number, I will keep working on it and see what else I can come up with.,
-
That was exactly what I wanted, and the code worked perfectly! Thank you! Caroline