Is there any easier way to do this than repeating it 90 times?

conditional formatting:

if formula is-----
=and(E36="Yes",[this cell]=O9) then strikethrough

My question is is there any variable for current cell or special
function I can use than retyping this in 90 different cells?

Thanks so much (again)

I promise this is the last feature I'm adding.

=and($e$36="Yes", [this cell]=$O$9), then strikethrough

use format painter to copy the format to copy the rest of cell


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Is there any easier way to do this than repeating it 90 times?
>
> conditional formatting:
>
> if formula is-----
> =and(E36="Yes",[this cell]=O9) then strikethrough
>
> My question is is there any variable for current cell or special
> function I can use than retyping this in 90 different cells?
>
> Thanks so much (again)
>
> I promise this is the last feature I'm adding.
>

What does "[this cell]" mean?

Do you have a range of cells you want to format like A1:A90? If so, you
don't need to enter the formatting in each cell one at a time. You can do it
to ALL of those cells in 1 step. You need to be more specific about this:

> =and(E36="Yes",[this cell]=O9)

Biff

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Is there any easier way to do this than repeating it 90 times?
>
> conditional formatting:
>
> if formula is-----
> =and(E36="Yes",[this cell]=O9) then strikethrough
>
> My question is is there any variable for current cell or special
> function I can use than retyping this in 90 different cells?
>
> Thanks so much (again)
>
> I promise this is the last feature I'm adding.
>