Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Beginner
What is the best way to change the range of cells a conditional formatting rule applies to?
Select the new cells in the sheet - click the small grid symbol next to “Apply to range” - click “OK”
Delete the conditional formatting rule and make a new rule
Click “Apply to range” - delete the listed cells - select the new cells in the sheet - click “OK"
Don’t know
2
Beginner
How do you set a conditional formatting to strikeout text when it meets a certain rule?
It is not possible to strikeout text using conditional formatting
Select the rule in the conditional formatting sidebar, click the “Strikeout” button in the Google Sheets toolbar
Select the rule in the conditional formatting sidebar, click the “Strikeout” button under “Formatting style”
Don’t know
3
Beginner
How do you see what conditional formatting rules are being used on your data?
Select the data and open the conditional formatting sidebar. All rules that apply to the selected cells are listed.
Open the conditional formatting sidebar. All rules that apply to the sheet are listed.
It is not possible to see what conditional formatting rules are being used on a sheet
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement