cond formatting

  • Thread starter Thread starter marcas91
  • Start date Start date
M

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.
 
=and($e$36="Yes", [this cell]=$O$9), then strikethrough

use format painter to copy the format to copy the rest of cell
 
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)
Click to expand...

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.
Click to expand...
 
Back
Top