Highlight Cells based on time stamp

Diego Casillas Zaragoza

Hello,

I would like to highlight all rows if "CREATED" cell is greater by 15 minutes than "MODIFIED" cell.

I have no idea how to go about it.

Genevieve P.

Hi @Diego Casillas Zaragoza

If you're using the two System Created columns, you can subtract one cell from the other to find out the difference between the two:

=Modified@row - Created@row

This difference will include time, meaning that if the number is greater than 0.01, the Modified date column is more than 15 minutes older than the Created date. Then you can set up a Conditional Formatting rule based on your formula column:

An alternative would be to use the Highlight Changes feature built into the sheet. (See: Highlight Changes Made to a Sheet)

Cheers,

Genevieve