I want to know how to get the conditional formatting to highlight a cell if it is equal to 1 year but less than 5 years, which i have managed to work out but when I want it to do it again for between 5 and 10, 10 and 15 and so on it stops working.
Can someone help me with this?
Last edited by Crazybitch; 06-07-2022 at 10:34 PM.
"It" is what? Just a number... or something else??
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Administrative Note:
Welcome to the forum.
Your thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. As you are new here, I have done it for you this time.)
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.
I've put in an attachment with the conditional formatting that I want it to do and you can see that the formatting is not working
Hi @Crazybitch
Do only one item, the others and so on, you have to do it like the picture
Thanks AliGW, I've never been on here before so don't really know the adequate.
Re: Conditional Formatting to highlight cells relative to date ranges
Thanks WK9128 you have fixed my problem, you're the best
@Crazybitch You're Welcome. Glad to help . Thank You for the feedback and rep.
If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- Please click on the *Add Reputation button at the bottom left. Whoever helps you, give it to whoever you like
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks