andyhutch2023
New Member
- Joined
- Jan 17, 2023
- Messages
- 2
- Office Version
- 2021
- Platform
- 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
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