Macro code in Excel is a programming code developed in the VBA (Visual Basic for Applications) programming language. Therefore, you will get values greater than 80 in red-marked cells. Select the formatting color in the right-side box.Select the Greater than option from the Formatting.Select the table and click the formatting sign right of the table.Make your dataset as with a table header.Here we will highlight the cell’s value which is greater than 80. In Excel, Conditional Formatting allows you to highlight cells with a certain color based on their conditions. Use Conditional Formatting to Apply ‘If Greater Than’ The result in the below screenshot is 84.333, which has come from the average value of marks greater than 80 ( 81.5,89,83.5).Ĩ.
0 Comments
Leave a Reply. |