I have a spreadsheet that I want to either "strikethrough" or gray out
text in cells based on whether there is an "x" in the one cell.

So for example.

Cells A4 to I4 have text and information in them. This information
when complete should show that it is complete. So when I put an "x" in
B4 I would like the whole line from A4 to I4 "gray out" or
"strikethrough" to signify that item is complete. If there is not an x
in the cell then I want the text in A4 to I4 to remain unchanged. I
tried conditional formatting but it didn't seem to do the trick.

Thanks in advance for any help you can offer.

-Karl