Change Colour on review Date

[timgarrett111]

Hi Bubblers

I have a text box showing a review date in a repeating group.

I’m wondering how I write a condition to show the background a certain colour when it’s within 30 days of that date, and a certain colour if it goes over that date.

Any help would be very much appreciated.

Kind regards

[louisadekoya]

A condition on the text box like When Current date/time +days:30 < current cell’s review_date might work, I think.

I may have that the wrong way round but I would try something along those lines.

[timgarrett111]

Super! Worked very well.

Thanks for your Help!