End Date (180) to (90) (90) to (60) (60) to (30) (30) to 0 0 to 30 30 to 60 60 to 90
6/30/29
Dear Gurus,
This is what I am trying to do, let's say, in the first column: If "end date" is between 180 and 90 days from today, highlight it (whatever color )...and so on, so forth.
It doesn't need to be a nested statement because I have seven columns for the different ranges.
Thank you for your help!
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Here is the sample. The goal is that the colors have to trigger actions on the user's part (outside of Excel).
Thank you again.
Originally Posted by arthurbr
In Conditional Formatting rules, try this formula.
Formula:
=AND(A$1<=TODAY()+180,A$1>=TODAY()+90)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Did you see arthurbr's signature? Take a look to it pls, because:
Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.
Will do; thanks
So take a look how my suggestion works..
Very smart; thank you. Will apply accordingly.
You are welcome and thanks for the feed back.
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. 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