I'm trying to conditional format based on below.
Column A has the year & Column B has the month:
Is there a way to conditional format Column A & B for the following:
Highlight in Orange a month before the due month.
Highlight in Green when the month is due.
Highlight in Red one month past the due month.
Any help would be appreciated. Thank you.
I think you are going to have to provide quite a bit more details than you have. How do we know when something is due, what does your "year" and "month" look like?
i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
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
Thanks for responding -
Sheet 1 (con 1) has Col A for the year and Col B for the month. I'm trying to conditional format based on the month against the year.
Sheet 2 (conf 2) - I've created Col C to provide a full date string in order to conditional format (to make life easier). (plan B).
However, the month and the year is the key thing.
If something is due in November 2012 - the month should go orange when its October (1 month before), Green in November (month due) & then Red for December (month expired).
Hope that makes sense.
For the "October" rule, use this...
=$E$1>DATE(B2,MONTH(DATEVALUE(1&" "&A2&" "&B2))-1,1)
For the "December"rule, this...
=$E$1<DATE(B2,MONTH(DATEVALUE(1&" "&A2&" "&B2))+1,1)
Is that for "use a formula to determine which cells to format" on the conditional format tab for Sheet 2? If so, would it begin at E2 not E1?
Yes, it is "use formula", and oops sorry, I neglected to say that I put the date (11/1/2012) in its own cell, sorry
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks