I want to apply conditional formatting to a range of cells within a row if every cell is filled.

[xcelnovice1]

Name	number	print	stamp	signed
JDoe	157568	x	x	x
Xcrod	489756	x		x

<tbody>
</tbody>

So I want to highlight a range of cells within a specific row if every column within that row is filled with any text. What formula can I use?

So in the above example, I would like the second row to be automatically highlighted when I type in the x under signed. I know how to highlight each row based on if only signed is filled. But I want the condition to apply ONLY when ALL the columns are filled within a row.

 

[Weazel]

if you select the range first and use something like

=COUNTIF($C2:$E2,"x")=3 as the conditional formatting formula