How to strike-through cells b2:l2 if cell a2=Done

[wmichael]

Hello,

Seeking advice on best way to strike-through cells B2:L2 if cell A2="Done"

Thank you in advance

 

[Eric W]

Select B2:L2. Click Conditional Formatting > New Rule > Use a Formula, and enter:

=$A2="Done"

Then click Format... and select the Font tab, and check the Strikethrough box.

If you want to do this on multiple rows, just select the entire range you want it to apply to and follow the same steps.

 

[wmichael]

Hey Eric,

Got it to work but not sure what to enter for a larger range, is =$A2="Done" correct for a larger range?

--- Michael

 

[Eric W]

Yes, the $A part of the formula means to always look at column A. The 2 part, without the $, means to looks at the current line, ASSUMING that the top line of your selection is 2. When you enter the formula, always enter the formula as if it were written for the upper left corner of the selection, and it will automatically change for the other cells in the selection.

So if you want it to work for the entire range of B:L (the whole columns), just select those columns by clicking on the column tabs, then click the CF > new rule > use a formula and enter:

=$A1="Done"

using the 1 since the upper left corner is row 1, and we're still looking at column A, so we use the $ to make sure it looks at A. Let me know if you get that to work.

 

[wmichael]

Yes the additional information you gave is working- thank you for your help!

--- Michael

 

[Eric W]

Happy to help!