Hi all.
I am trying to have 4 levels of format...
Less than 8 weeks elapsed
=TODAY()<=F2+56
Between 8-10weeks
=AND(TODAY()>=F2+56,T0DAY()<F2+70)
Between 10-12 weeks
=AND(TODAY()>=F2+70,T0DAY()<F2+84)
Over 12 weeks
=TODAY()>F2+84
As you can see the less than 8 and more than 12 are working but not the 2 in betweens. Can't figure what i've done wrong
formatscreenclip.png
Last edited by DJTUK; 09-24-2021 at 08:13 AM.
Well, that does nothing to explain what your problem is. Please try to describe it in words.
Pete
Sorry, was trying to delete one of the attachments
It would also help if you attached a sample Excel workbook, rather than a picture of one. To do this, follow the instructions in the yellow banner at the top of the screen.
Hope this helps.
Pete
Here it is, thanks Pete.
You still haven't explained what you are trying to achieve.
Which two are not working as you wish and what results do you want from them??? How can we know from non-working formulae what your intentions are?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Works fine.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Hi, thank you for looking. That is exactly what I'd hoped to see. However, when I open it the light greens and golds just aren't working and I'm exasperated to the point of utter despair lol. I don't suppose you can think of a reason why this might work for others and not myself. (The sheet I posted is literally the original, just with the extra sheets and data removed.)Originally Posted by KOKOSEK
Change T0DAY to TODAY and also remove the "$" sign.
Additionally, sort out the overlapping: =TODAY()<=C3+56 and =AND(TODAY()>=C3+56,T0DAY()<C3+70).
Wow, how the 0's got in there I'll never know. Worked a treat, thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks