Forum Discussion
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
- OliverScheurichGold Contributor
=$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-LearnerCopper Contributor
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!