cond formatting

[marcas91]

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.

 

[Bobocat]

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

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

 

[Biff]

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

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.