Quote:
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
|
Thanks for your help it worked fine.
Regards
Paul