FlashHazzard
New Member
- Joined
- Oct 24, 2019
- Messages
- 2
I have a database where I need to prompt the user to change a specific code number when a new month begins.
I have tried using the following (C is the assigned date column and F is the code # column)): =C18<=EOMONTH(TODAY(),-1). This does highlight the code column cell but I want it to apply to only the cells that has a code number of "1".
Or is there a better way to automatically change the code number once a new month has begun using another function or macro?
I have tried using the following (C is the assigned date column and F is the code # column)): =C18<=EOMONTH(TODAY(),-1). This does highlight the code column cell but I want it to apply to only the cells that has a code number of "1".
Or is there a better way to automatically change the code number once a new month has begun using another function or macro?