Trying to get cells in column S of attached to highlight in dark red if adjacent cell in column U is empty and date in column S is 90 or greater days than today function.
Also using same principle, Trying to get cells in column S of attached to highlight in light red if adjacent cell in column U is empty and date in column S is 60 to 89 days greater than today function.
Also need this to continue down through entire workbook and not stop at a particular row number.
thanks.
The formula for the condition refers to row 3 while the scope refers to S:S which actually is S1:S1048576
In this way you're specifying an offset.
Change the row in the condition to row 1 and it'll work fine.
BTW the first condition (purple) is referring the column R. Shouldn't that be column S?
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
http://www.excelforum.com/excel-form...-of-cells.html
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks