Hi, i'm an excel noob. i know the program can do this, i just don't know how.
I do landscaping, and i need to know how long it's been since the last time each lawn was mowed.
so something like:
If [last mowed] > [8 days ago] then [highlight row].
or something. i just need the functions and i can play around.
THANK YOU!
Last edited by Zeroable; 05-21-2015 at 06:45 PM.
you need to combine 3 things
1> if formula
http://www.techonthenet.com/excel/formulas/if.php
2> today formula
http://www.techonthenet.com/excel/formulas/today.php
3>conditional formatting
http://www.contextures.com/xlCondFormat01.html
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi, welcome to the forum
Actually, before you do those 3 things...
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)
Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
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 your response!,Originally Posted by humdingaling
Ok, so i'm trying. it's not working so far. this is what i have as a conditional format:where's my error?
Please Login or Register to view this content.thanks
i did however get a column to report a true or false on those with the formula ofPlease Login or Register to view this content.
Last edited by Zeroable; 05-21-2015 at 09:24 PM.
You need to remove the "", and iof this is for CF, you dont need the IF() part...
=IF("TODAY()>[Last Date Done]+7",TRUE)
=TODAY()>[Last Date Done]+7
i mocked something up for you yesterday
was awaiting for you to comply with Mods request before attaching
see attached to help you see how it can work
This is perfect! thank you!
one other question: is it possible to highlight the entire row? or the customers name (in the same row) ? this will work regardless. thank you!
i dont recommend doing the whole row just do enough for what you need
check where it says applies to
eg change applies to
=$A$2:$A$25 to =$A$2:$O$25
you can change the O to how long you want it to be
ok this is fun.
Can i make it so that the longer it's been, the darker the red? (change colors).
if i make another rule it just overrides the last rule..
thanks again
The color gradient is not available for the "use Formula" rule
1 option would be to make additional rules with, say, 1 week decrements, and then have a different color for those. Something like...
=A2<=TODAY()-15
make this another color
=A2<=TODAY()-22
Make this another color
awesome, thanks!
i realized that the order in which they are listed is important, as one will override the last. thank you for your quick help
Yes, the order is important, good catch there. Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks