Here's my problem:
I have a date column (Column E: Date Entered) on my spreadsheet that I need to set conditional formatting on. There are two conditions:
1) 18 months from the date in the cell needs to be highlighted yellow
2) 24 months from the date in the cell needs to be highlighted red
It seemed simple enough when I started but I'm having trouble figuring this one out. Any advice would be much appreciated.
Thank you,
Amanda
Sorry, not clear: which cells are you trying to conditionally format, and based on which dates?!
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
I am trying to conditionally format all of the cells in Column E. There is currently only data in E10 and E11 but eventually there will be data in all cells in column E. The dates are based on those dates in column E.
The reader needs to know immediately upon looking if the date that they entered into the program is getting close to (18 months) or at (24 months) the certification period end date. Sorry for not being clear, I'm not yet used to the forum. Let me know if this answers the question.
So if the date in column E is more than 24 before todays date, colour cell red, is that correct?
And if the date in column E is more than 18 months before todays date, but less than 24 months before todays date, then colour the cell yellow? Is this the right logic?
Yes that is correct.
Okay. So, in cells E8:E21, apply the following conditional formatting formulas:
Colour red:
Formula:
Please Login or Register to view this content.
Colour yellow:
Formula:Please Login or Register to view this content.
This worked like a charm! Thank you so much for your help. Just had to make sure the 2nd condition didn't override the first and I was set. Much appreciated!
Hi Im trying to do something similar to where I have dates in column F I want to conditionally format to highlight orange if today's date is within 18 months of the date in column F.
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar or even the same as this thread, we have a rule that you open your own thread on the issue and do not piggy back another member's thread.
Please see Forum Rule #1 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
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