Forum Discussion

Excel-Learner's avatar
Excel-Learner
Copper Contributor
Apr 23, 2022

Apply Strikethrough if values in another column are 100%?

Hello,

 

I have a to-do list. In column C I have listed my tasks and in column G I have a percentage for the tasks.

I would like to add a conditional formatting so that the task in column C gets stroke through if the value in column G for that row = 100%.

 

So if I change any value in any cell in the column G too 100%, I want it to apply the strike through formatting to the value of the cell in the same row in column C. E.g. I change Row 5, Column G to 100%, it should strike through Row 5, Column C.

 

I can construct the rule for one cell but not for the whole row!

 

I tried in conditional formatting: =$G1="100%" but it doesn't work!

 

Would vastly appreciate any help. 

 

Thank you!

 

2 Replies

  • Excel-Learner 

    =$G1=100%

    Do you want to apply the format to the whole row? Then you can try above formula and this "applies to" range:

    =$1:$26

     

     

    • Excel-Learner's avatar
      Excel-Learner
      Copper Contributor

      OliverScheurich 

       

      oh wow, now it works! not sure what I did wrong. I had tried with the " and without.

       

      In any case, thank you ever so much!

      Cheers!

Resources