I have information from Rows A to G for a customer. Col G is Latest Service. Col F is Last Visited. I have a condition format that is not working correctly. I basically want a macro or condition format that if the date in Either G or F + 14 days is >NOW().. As in if its been 2 weeks since their last service or visit the row will be red. if not.. it will be white or light gray or whatever i want it to be.
You mean?
Select All rows to affect between Row 2 and bottom and go to Format|Conditional Formatting
Select Formula Is and enter.
=OR(TODAY()-14>$G2,TODAY()-14>$F2)
Click Format and choose Red from Pattern tab.
Click Ok,
Click Add
Select Formula Is and Enter:
=AND(TODAY()-14<=$G2,TODAY()-14<=$F2)
click Format and choose colour..
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
i'm actually making into a macro.. I have this so far
I want it to keep going down the cells though doing the same thing unless it runs out of data..
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks