Hi, I need a formula or automation to do this:
If Days <10 but >0, then color row yellow
If Days<=0, then color row red
Thanks,
Hey Gabrielle! Shannon here with the monday team. 
Thank you for submitting this feature request!
To clarify, when you say “days,” are you referring to the number of days from today and the dates entered in a Date /Timeline Column? With conditional coloring, you can specify different durations, such as a date “on or before” X,
OR between specific dates.
However, these conditional coloring options don’t sound like they address your specific use case, is that correct? Could you please share additional context about what you’ve set up on your board and what you’re looking to achieve? While conditional coloring doesn’t provide us with the duration you’ve outlined, I think we can achieve what you’re looking for with both an IF formula and conditional coloring. I can help you with a formula if you share more details with me. 