Formula/Macro to Trigger Highlighted Cells For Something Due in 10 Days
I am trying to create a document where the initial entry will be the date something was stored, then creating a formula or macro to highlight that field after 10 days. For example: a box was stored on 01/01/2024. When 01/11/2024 occurs, I want it to be highlighted yellow so we know to dispose of the box. Is this possible?
use Conditional Formatting
With date in A1: in Conditional Formatting
"use a formula ....."
Formula:
Please Login or Register to view this content.
Set "Fill" to yellow
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks