bradccollins
New Member
- Joined
- Nov 4, 2011
- Messages
- 29
trying to return a value for a sum of time in a set number of days, i have it working so that I can get a yes no answer, and have that conditionally formatted to return green for yes and red for no. What I would like to do is have a third option which I can format orange when the time gets within a certain window before expiring.
This is my formula so-far:
=IF(C3+C4<100,"YES","NO")
So for this I would also like a return of "NEARING" if C3+C4 is greater than 90 but less than 100.
If it has to be done in a macro then I'll forget it, but if it can be done with the formula that would be great!
Thanks in advance.
This is my formula so-far:
=IF(C3+C4<100,"YES","NO")
So for this I would also like a return of "NEARING" if C3+C4 is greater than 90 but less than 100.
If it has to be done in a macro then I'll forget it, but if it can be done with the formula that would be great!
Thanks in advance.