Conditional Formula to highlight all dates = Today
![SherryFox](https://us.v-cdn.net/6031209/uploads/userpics/LHA9XZ0T0H53/nMRKE1FQSRA0S.jpg)
I am still working on my same template. Now there are multiple dates that are using formulas. I would like to be able to use a formula within conditional formatting for this range. When I attempted to do this and selected the word "today" it put in today's date. When tomorrow arrives, that will obviously not be helpful. Basically what I want is:
Highlight all dates = TODAY in bright Yellow
Sherry Fox
Business Process Analyst 3 | C5ISR Group | HII | Mission Technologies
EAP | Mobilizer | Automagician | Superstar | Community Champion Class of 2024
Core App Certified 🦊
NEW (Work) Profile: @SherryFox | OLD (Personal) Profile: @Sherry Fox
Connect with me on LinkedIn
Please Like ❤️, Vote Up ⬆️, Awesome 🤩, Insightful 🧐 any of my contributions that have provided value.
Best Answer
-
Hi @SherryFox,
As long as your column is a date column you can try the following. Instead of typing in Today with an operator like "is equal to", use the Date "is today" criteria.
Is that what you're trying to accomplish? It seems to have worked for me, and will work tomorrow and everyday thereafter.
All the best,
-Ray
Answers
-
You should be able to do this directly in conditional formatting:
-
Hi @SherryFox,
As long as your column is a date column you can try the following. Instead of typing in Today with an operator like "is equal to", use the Date "is today" criteria.
Is that what you're trying to accomplish? It seems to have worked for me, and will work tomorrow and everyday thereafter.
All the best,
-Ray
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!