I am trying to set up conditional formatting on an existing Excel worksheet
that has information in cells B1:F1 to B203:F203.
What I want to happen is that when I type "ok" in a cell in column A [i.e.
A1], the text in columns B to F [B1:F1] should Strike Through.
I was successful in setting this up on one row.
Keeping in mind that the format is set up on the cells that already contain
text, how do I copy the format to all the other rows without doing it one by
one?