Oct 11 2020 03:06 PM
I am new to excel and looking for a way to make things automatic. I want to make a table with a yes or no toggle cell and do certain actions like... if no, to apple a strikethrough and fade to text and if yes, to make no changes. can this be done? here is a picture for reference.
Thanks in advance.
Oct 12 2020 01:53 PM
You may apply conditional formatting rule to the range as
Be sure with absolute/relative reference.