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

Attached Files

Windows dimensions 190429 BA.xlsm (30.9 KB, 9 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post