View Single Post
 
Old 05-10-2019, 02:53 AM
Paul_ Paul_ is offline Windows 10 Office 2019
Novice
 
Join Date: May 2019
Posts: 2
Paul_ is on a distinguished road
Default conditional formatting

Quote:
Originally Posted by Pecoflyer View Post
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
Reply With Quote