Forum Academy Marketplace Showcase Pricing Features

Change Colour on review Date

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

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.

1 Like

Super! Worked very well.

Thanks for your Help!


1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.