Hello,
I need help good people.
I would like to change colours of cells based on date range in other cells.
For example:
cell a5=26.06.2019
cell a6=29.06.2019
and now i wish that cells A4:C4 get some colour.
Is it possible with conditional formating?
Last edited by AliGW; 07-01-2019 at 12:47 AM.
Welcome to the forum!
What is in cells A4:C4?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Are those dates real dates?
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 will be name of the person.Originally Posted by AliGW
Welcome to the forum!
What is in cells A4:C4?
Yes, real dates, but I will use all of the dates from the whole year, time range can be diferent.
I am having trouble visualizing your set up. The range of dates between June 26 and June 29 is 4 days inclusive. The range of names in cells A4:C4 would be 3. Seems as if there would have to be some linkage between the names and dates, as in a list of consecutive dates row 3. Perhaps if you could upload a small desensitized sample of your data it would make it easier for someone to help.
To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hello,please see if my attached file will help you understand what i'm up to. My attached file is: colour cells based on date range
Thank you
See if the following helps.
Modify the formula in D8 to read: =IF(D7="",MAX(0,C8-1),IFERROR(IF(D6=D7,1,D7-D6),""))
(Note that zeros are hidden using custom formatting 0;;;@)
Modify the last conditional formatting rule for row 3 to read: =D8>0
Let us know if you have any questions.
Hello,
i am speechless, thank you so much for your help. Fantastic this is even better than i expected! :D
You're Welcome. Thank You for the comment and for marking the thread as 'Solved'. I hope that you have a blessed day.
For future reference, please select Thread Tools from the menu link above and mark this thread as SOLVED. I have corrected it for you this time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks