Hi,
I have a database with dates complaints were received in column D. In column G there is a date the response was sent. I need cells for dates in column G that are 10 days past the corresponding date in column D to turn red. I have tried sorting this out for the last 2 hours and am pulling my hair out! Thanks!
does this help?...
basically you substract your date in col G from Col D and see if it's greater than 10
=$G1-$D1>10
format to Red background with white letters....
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
No this did not work. I have 278 rows of data starting with G2 and need each cell in G to be subject to the 10 days past D condition. I have a second rule set up for blanks in G to turn red as well. Please let me know what other info would be helpful, this is driving me nuts!
What about Judge's solution "did not work"? I extended his solution down to row 332 and it seems fine? If this is still not what you want, then can you upload an example workbook showing what you expect to happen? (Go Advanced>Manage Attachments)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
False alarm! Judge's solution worked perfectly, I just didn't have the right area selected *smh* Thank you thank you!
glad I could help and thanks to ChemistB for the confirmation...
If this has been completed to your satisfaction, please set the thread to Solved...If you feel we deserve an increase in our reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be us...just a thought...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks