excel gurus

[Nash B.]

No, using <Column> from above, =COUNTIF($<Column>$1:$<Column>$<Bottom>,TRUE)=0 would set them all red if there's no Done in Column G. =<Column>1 checks the first value and applies that to A1, then checks the second value and applies it to A2, and so on for the entire range.