what is ment by conditional formating
Answers
Answer:
Conditional formatting is a feature of Excel which allows you to apply a format to a cell or a range of cells based on certain criteria. For example the following rules are used to highlight cells in the conditional_format.py example: worksheet.
Explanation:
Conditional Formatting (CF) is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula. For example, you can have a cell appear bold only when the value of the cell is greater than 100.
Different types of conditional formatting
Apply a logical rule (as superior, inferior to a value)
Highlight the highest or lowest value.
Insert data bars in cells proportional to values.
Create a color scales of 2 or 3 colors that varies according to values.
Add icon sets.
Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that meet certain criteria. It is most often used as color-based formatting to highlight, emphasize, or differentiate among data and information stored in a spreadsheet.
You really only have to follow three simple steps.
Step 1: Select the cells you want to format.
Step 2: Click the Conditional Formatting button under the Home menu, Styles section.
Step 3: Select your rules. There are Highlight Cells Rules and Top/Bottom Rules at the top that let you do comparisons with values.
,
hallo hope it helps you dear
follow me and make my ans brainliest one
stay home stay safe take care bye