I am attempting to create a conditional formatting that changes the color of a shape based on if it is in the same month as this month. I have discovered the NOW constant to be used in formulas but I can't figure out how to use the formula Month(NOW) in conditional formatting. This image should give an idea of how I think it should work.
I figured it out. You have to use a formula as the data source as value is read as a string literal and not interpreted as a formula even if you use curly braces. It might be nice to be able to use curly braces for a formula anywhere in the program. The formula ended up looking like: WEEK(DATE(YEAR(NOW)@"Ship By Month"@"Ship By Day"))=WEEK(NOW)
Hi David
Thanks for posting in the Community we're glad to see you managed to find a solution! This will certainly be valuable to others in the future thanks a lot for coming back to the thread and sharing your answer!
Reply
Create an account in the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in to the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in with Lucid
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.