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 s...
=$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
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!