How do I construct the formula below for conditional formatting if I want my condition to be met,
IF $V13<>""
AND either of the other columns listed =""
=AND($V13<>"",$X13="",$D13="",$E13="",$F13="",$H13="",$I13="",$J13="",$K13="",$L13="",$M13="",$N13="",$O13="",$P13="",$R13="",$S13="",$T13="",$W13="")
Thanks
Dan
IF $V13<>""
AND either of the other columns listed =""
=AND($V13<>"",$X13="",$D13="",$E13="",$F13="",$H13="",$I13="",$J13="",$K13="",$L13="",$M13="",$N13="",$O13="",$P13="",$R13="",$S13="",$T13="",$W13="")
Thanks
Dan