Conditional Formating

how do i do conditional formatting for average total lower than 80%??

Follow the below steps to do the conditional formatting:

• Select the cell or the relevant range of cells to be formatted (here in you case select the cell range where you display average range)
• On the Home tab Click “Conditional Formatting“.
• Choose New Rule, select a rule type and edit the rule description.

Here you can specify the condition in this rule saying that the value > 80 then mention what format change you need.

Thanks,

please attach the excel file or screenshot of the file so we can guide you.