what trying achieve if cell in column ab equals "yes" , cell in column ac blank, range of cells formatted. rule not formatting cells should. basing code on formatting rule using works properly, not use and().
=and(indirect("ab"&row())="yes", indirect("ac"&row())="") i sure obvious syntax mistake, still new excel , can't figure out why isn't working.
try this:
=and($ab1="yes",$ac1="")
use format painter drag formula around.
as jeeped said, change 1 in $ab1 , $ac1 first row.
Comments
Post a Comment