conditional formatting

[Dummy Excel]

hi all,
hope everyone is safe and well in these conditions.

my question is, i have setup a checklist with multiple columns and rows.
I want to set conditional formatting up for the header row (row1) so that when all the rows (123rows) aren't blank (have a comment or date entered), it changes the header to green.

thanks
Sam

 

[jasonb75]

Assuming header in A1, data in A2:A123, try this as a conditional format rule.

=COUNTBLANK(A2:A123)=0

Note that if you have merged cells then you will encounter problems.

 

[Dummy Excel]

jasonb75, appreciate the reply. it works 100% thanks