Hi everyone,
I am trying to modify this formula DATEDIF(C2,D2,"m") so it includes today’s date instead of having a designated. Also, I would like to include in a Conditional Formatting to change the color of the cell to green if the value in B2 is equal or greater than 12. Could someone tell the best approach to this problem? See attachment for detail.
Thank you very much in advance.
Last edited by Kimston; 02-25-2012 at 06:29 PM. Reason: solved
you can use the function =DATEDIF(C2,TODAY(),"m") to calculate your dates, as for conditional formating, you can create a new rule and use the "Format only cells that contain" option, then use greater than or equal to, and put in 12
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
Hi,
See attached
Regards
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 very much Richard. It worked perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks