My report has a formula that changes text in "L" column based on the date (column "K" being greater than 300 days. I want to highlight and change column "L" text if date in column "K" is greater than 30 days past date.
I'm not sure if this can even be done in conditional formatting or if it will work better in VBA,
Any help would be WONDERFUL!
Thank you!
Hi,
You can't use conditional formatting to change the value of a cell - only what the contents of the cell looks like.
But if column L is a formula why not just extend the formula - presumably with an IF test which tests whether the column K date is 30 days past 'date', but you;ll need to explain what you mean by 'past date'.
Upload a workbook with some examples and manually add the results you expect to see with different scenarios.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you for the quick response! I'm not an expert at this so can you please explain in a little more detail?
Hello Tweet76 and Welcome to Excel Forum.
I believe that Richard is asking you to upload a sample of the report (spreadsheet) of which you spoke in post #1 (My report has a formula that changes text in "L" column...). It would help us to help you if you could tell us what you want to happen with the cell in column L that isn't happening now.
To upload a sample spreadsheet 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.
Please see attached "Sample" file.
Hi,
Would you manually add the results you expect to see and clearly indicate which cells are the results and which are original data and add a note explaining how you calculated the results
Your original said or at least implied that column L contains a formula, however the file you sent simply contains manually entered dates so I'm somewhat confused.
The "Review Status" (column M) is determined by the "Approval" (column "L"). The current rule is =IF(L4="XXXXX","Unapproved",IF(L4+300<NOW(),"REVIEW DUE","CURRENT")). I would like it to calculate anything over 30 days (13 month, 395 day, etc..) and change to "Over Due" and highlight. I want the status of "Review Due" to change to a color. I hope this makes sense.
Please do what Richard has asked and then attach the amended version of your file. Thanks.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks