Apply conditional formats
Conditional formatting is all about highlighting data that are based on certain conditions. Zoho Sheet supports three types of conditional formatting, namely, Classic, Color Scale and Icon Set.
To apply classic:
- Select the range of cells you wish to apply classic conditional formatting to.
- Tap
under the Home menu.
- Select Classic from the options.
- Select the cell range, set the criteria, and choose any formatting options from the Classic dialog.
- Once you're done, tap OK.
To apply color scale:
- Select the range of cells you wish to apply color scale to.
- Tap
under the Home menu.
- Select Color Scale under the Conditional Formatting menu.
- From the dialog, select the range you wish to add color scale to.
- Pick the desired color from the available color range or customize the color. Specify the values for Minimum, Midpoint and Maximum parameters.
- Once you're done, tap OK.
Type - The type of value for which you wish to apply color scale. For example, number, percentage, formula, etc.
Value - The minimum, midpoint and maximum values you wish to apply color scale to.
Color - The color you wish to apply for minimum, midpoint and maximum values.
Hide Cell Content - To hide the cell content or not once the color scale is applied.
Automatic Text Color - To apply the current font color in the worksheet to the values or stick to the default font color.
To apply icon set:
- Select the range of cells you wish to apply the icon set to.
- Tap
under the Home menu.
- Select Icon Set from the options.
- From the dialog, select the sheet you wish to add icon sets, pick the type of icons, and other parameters like Rules, Values and Types.
- Once you're done, tap OK.
Icons - The type of icon set you wish to indicate the values.
Display Icon - The type of icon you wish to indicate each value.
Rules - The rules you wish to apply for the values.
Values - The minimum, midpoint and maximum values you wish to apply icon set to.
Types - The type of value for which you wish to apply icon set to. For example, number, percentage, formula, etc.
Reverse Icon Order - To reverse the order of the given display icons or not.
Hide Cell Content - To hide the cell content or not once the icons are applied.
Keep Default Icon Size - To maintain the default icon size or not when the font size of the respective cell is increased.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Apply conditional formatting to your cells
What is conditional formatting? With conditional formatting, you can predefine the format that you want your cells to have, based on a few criteria. Zoho Sheet lets you format your cells with four different types of conditional formatting. They are, ...How to highlight the entire row with conditional formatting
Conditional formatting in Zoho Sheet allows you to highlight the entire row either using formulas or without formulas. To highlight the entire row with a formula: Navigate to Format > Conditional Formatting > Classic > Formula. Enter the desired ...Change/edit the conditional formats already present in a sheet
To manage conditional formatting: On the menu bar, click Format > Conditional Formatting > Manage Rules. View a rule that has been created in an expanded or a collapsed mode. Choose to edit, copy or clear the rules that have been set and listed under ...Apply and customize Themes
Themes are one of the formatting options that allows you to change the color, font, and effect of your spreadsheet. Themes are applicable for charts, tables, sparklines, hyperlinks, text, etc in your spreadsheet. To apply any theme to your ...Clear values or formats in a cell range
To clear values or formats in a cell range: Select the desired range and go to the icon. Under Home, choose Clear. From the given list, you can choose to clear the content, formats, conditional formats, data validation, notes, and hyperlinks. To ...
New to Zoho LandingPage?
Zoho LandingPage Resources