So I'm trying to figure out how to set up my spreadsheet so that only numbers that fall within a certain range values will be identified or isolated

For a better idea of what I'm talking about:

\1

In the duration column, I want to be able to do something along the lines of highlighting every row that is close to 27 min (so the range would be something like 26 to 28 min) green and then every other row that falls outside of that range, highlighted as red.

Does anyone know if there is a formula that I can use to do that and then macro it so everything automatically repeats in that method whenever I load newer rows of data onto this spreadsheet?

Basically in short, I want to be able to automatically highlight every cell that is close to 27 min as green and everything else that is not close as red. How do I do that without having to click on every single cell and changing the color manually? Thanks