I want to include some due dates to a spreadsheet I currently have. I want Excel to alert me 7 days before the due date. I am using conditional formatting. I'm using "Format only cells that contain" --> "Cell Value" --> "Less than" --> "=Today()+7". This works great, however, I need to format the entire column and not every cell in that column will have a date. I want the blank cells to stay blank but it's changing. Any idea on how to exclude the blank cells in my situation?
Check out the AND statement and the ISBLANK statement....HTH
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
I'm probably writing the formula wrong but I have:
="and($A1<today()+7,not(isblank($A1)))"
It's still not working. It alerted all the cells.
Should work...
Please Login or Register to view this content.
This worked great for the blank cells but then it highlighted all the dates, even the ones that are due more than 7 days from now. Any idea why this is happening?
which formula did you use? Mine or ledgerly's?
I used yours.
thats weird because I tested that on a date data set....can you upload the file with the dates?
This is just a test document with random dates.
I see the issue....when you put this into CF I put in --- Use a Formula to determine which cells cell to format....not the Format all cells based on their values....check it out....
Ahhhh! Perfect! It works now. Thank you SOOOOO much!!
you are very welcome
thanks for the Star
@ledgerly....thanks also
ignore my weird posts....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks