Using white color font is very smart trick! I am planning to use it to hide the info that I don't need to see but need for filtering. Spreadsheet looks clean and beautiful, thank you!
@@PenguinprofI use conditional formating. I make a small column beside the question, for example column A. Column B is the question. I make conditional formating in column B, =$A2="-" then I choose yellow. You can modified the symbol "-" and colors. So every time i type "-" in the column A, the column B will change the color to yellow. I use the same method to hide the answer. Column C for the command Column D for the answer (all the font are white) Then making conditional formating in column D, =$C2="-" then I choose black color for the font. If I type "-" in the column C, the column D will show the answer with black color font.
Using white color font is very smart trick! I am planning to use it to hide the info that I don't need to see but need for filtering. Spreadsheet looks clean and beautiful, thank you!
Glad it was helpful! Good luck with your studying!!!
@@PenguinprofI use conditional formating.
I make a small column beside the question, for example column A. Column B is the question. I make conditional formating in column B, =$A2="-" then I choose yellow. You can modified the symbol "-" and colors. So every time i type "-" in the column A, the column B will change the color to yellow.
I use the same method to hide the answer.
Column C for the command
Column D for the answer (all the font are white)
Then making conditional formating in column D, =$C2="-" then I choose black color for the font. If I type "-" in the column C, the column D will show the answer with black color font.
I love this!
I'm so glad!!!