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, 11 views)

__________________
Using O365 v2503 - 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

Thanks for your help it worked fine.
Regards

Paul