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?

I find that the easiest way to set up conditional formatting is to select the
entire range that the conditional formatting is to apply to and then insert
the condition as if it applies to the first cell in the selection only (that
is the cell that is still white). Excel then looks after applying the
condition to the remaining cells.

You do have to consider whether to use any absolute addressing in the
condition and you do this by applying the same rules when entering any
formula in a cell and you need to consider whether absolute, partial absolute
or relative addressing is required if you are going to copy the formula to
other cells.

Alternatively you can select the cell with the format and Copy then select
the entire range to be conditionally formatted (including the one copied) and
Paste Special - Formats.

--
Regards,

OssieMac


"Mags" wrote:

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?