Help with average and conditional format

andyhutch2023

New Member
Joined
Jan 17, 2023
Messages
2
Office Version
  1. 2021
Platform
  1. Windows
Hi

I am an excel newbie and have the following simple problem. I have a range of cells and want to say if the average is equal to or less than 3.6 then turn the cell red, if the average is between 3.7 and 8.4 then turn the cell yellow and if the average is between 8.5 and 12 turn the cell green.

thanks
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
how about setting up 3 rules
=AVERAGE(A$2:A$9)<=3.6
=AVERAGE(A$2:A$9)<=8.4
=AVERAGE(A$2:A$9)<=12

Put in order Red,Yellow, Green and use STOP IF TRUE

May want to adjust as you may get fractions and so what colour would 3.65 be ??

Also need to adjust the range to match your data

Row 12 - is just for info to see what the actual average is

is this the sort of thing you meant



Book46
ABC
1
2
3138
4149
5138
6249
7359
8249
9249
10
11
121.714285713.857142868.71428571
Sheet2
Cell Formulas
RangeFormula
A12:C12A12=AVERAGE(A2:A9)
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A2:C9Expression=AVERAGE(A$2:A$9)<=3.6textNO
A2:C9Expression=AVERAGE(A$2:A$9)<=8.4textYES
A2:C9Expression=AVERAGE(A$2:A$9)<=12textYES
 
Upvote 0
Solution

Forum statistics

Threads
1,213,510
Messages
6,114,044
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top