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

[xcelnovice1]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]number
[/TD]
[TD]print
[/TD]
[TD]stamp
[/TD]
[TD]signed
[/TD]
[/TR]
[TR]
[TD]JDoe
[/TD]
[TD]157568
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[/TR]
[TR]
[TD]Xcrod
[/TD]
[TD]489756
[/TD]
[TD]x
[/TD]
[TD][/TD]
[TD]x
[/TD]
[/TR]
</tbody>[/TABLE]
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