Paragraph text Conditional Formating

1

I have a formula in a paragraph that calculates the latest date in a table and then subtracts this from today to show time since.

It’s meant to be a shame number, is there a way to apply conditional formatting to show green if less than 10 and red if > 10 days for example.

This is not a table column just a part of a paragraph.

2

You cannot do that with valid means.

You can use a hidden _Color() formula to apply character level styling, such as background and foreground:

image

Not the same flexibility as conditional formatting, but you have a few options to choose from.