Originally Posted by Pecoflyer

Hi and welcome
I adapted it for column T, same method applies to other columns
You have to use a relative reference for the rows like $T4 not $T$4
You should also apply to the entire range
Perhaps adapt your formula for error values in col S like
=ISERROR($t4) and format as required