Thanks for the response.

So if I have 5 minutes, that would be equal to 300 seconds. Am I correct? So I have to apply the rule to every cell so the amount of seconds is calculated and the highlight is applied to the cells based on the NOW() function?