Conditional Formatting Question

[BHuffXLnovice]

I have a column of checkboxes ( cells A23:A150). These checkboxes are linked to column AA (cells AA23:AA150) which returns a "TRUE" or "FALSE". I would like to set up a conditional formatting where when AA23 is TRUE a range of cells in that row (columns B-W) are formatted for strikethrough. This part I am able to do myself. The more challenging part that I am unable to figure out is how to apply this logic to AA24 and its row range, AA25 and its row range, etc. When I try to copy the formula from row 23 and apply it to subsequent rows, a TRUE in AA23 is what changes B24:W24 to strikethrough, when it should be a TRUE in AA24 that changes it. Any help that can be provided would be appreciated. Sorry if my explanation is not all that clear.

 

[Special-K99]

Select B23:W2

Conditional Formatting
New Rule
Use a formula to determine...

=($AA23=TRUE)

Format as required
Use Format painter (paintbrush icon) to copy to other cell format to other rows

If this doesn't work select just B23 and paste as above to W23
Then paste to other rows.

 

[BHuffXLnovice]

That worked, thanks. Stupidly, I didn't realize when I had tried that before that my AA23 was set up as $AA$23, which threw the whole thing off. Thanks again!