Explain any four options included in Highlight cells rules conditional formatting
Answers
Imagine you are recording monthly results in the example spreadsheet on the right, and you want to apply Excel Conditional Formatting to your cells, so that a monthly figure is highlighted if its value is greater than 60.
To do this:
Select the cells to be formatted (i.e. cells A2-D6).
Click on the Excel Conditional Formatting option from the Home tab of the Excel ribbon.
Conditional Formatting Greater Than Example in Excel 2010From within the 'Conditional Formatting' drop-down menu, select the Highlight Cells Rules option and from the secondary menu that appears, select the Greater Than ... option (see right).
The Conditional Formatting 'Greater Than' dialog box should then pop up (see below). Within this dialog box, enter the value 60 into the first input field (entitled 'Format cells that are GREATER THAN:').
Select a pre-defined format from the drop-down list on the right of the dialog box and click OK.
These selections are shown in the following image of the Conditional Formatting 'Greater Than' dialog box:
Conditional Formatting Greater Than Dialog Box Showing Value Condition
A B C D
1 Month 1 Month 2 Month 3 Month 4
2 20 60 50 20
3 60 30 20 30
4 30 30 70 70
5 80 20 40 10
6 50 90 10 50
The resulting spreadsheet is shown on the right. As required, all cells containing values that are greater than 60 have been highlighted.tion:
Answer:
This is your answer
Hope this helps you
