Conditional formatting if in last 15 mins

[Undo]

Hello

Looking to highlight the cells that contains time in last 15 mins
how can I do it with conditional formatting?
cells= A:A

[6StringJazzer]

NOW() is volatile so will be recalculated any time any calculation is done. However, it will not update if the file just sits there. You will have to hit F9 to refresh it if no other calculations are happening.

This assumes that the cell has only time, not date. Can you be more specific about your data?
Applies to $A:$A

=A1>(MOD(NOW(),1)-TIMEVALUE("00:15:00"))

If the cells have date + time

=A1>(NOW()-TIMEVALUE("00:15:00"))