Hi you all! I had another question. I want t...

Hi you all! I had another question.

I want to change the color of an entire Row based on a Changetimestamp. How can I create a format, that only change the color of that entire Row if the Changetimestamp is “=” TODAY?

My Changetimestamp column is looking for all the columns of the table, soo if any changes happen it trigers the action of Changetimestamp.

Then I create virtual columns that Fetch Year/Month and Day of the

Changetimestamp column.

I made a format rule: AND(([Changetimestamp]=[Year Changetimestamp]),([Changetimestamp]=[Month Changetimestamp]),([Changetimestamp]=[Day Changetimestamp]))

The result is that is changing the color of all the data.

How can I only change the colour of the particular Row that has change the Changetimestamp?

0 4 274
4 REPLIES 4

Try the condition [Changetimestamp] > TODAY()

Or possibly >TODAY()-1

may work?

TODAY() - 1 should show everything yesterday and today

@praveen

Thanks!

I will try that!

Top Labels in this Space