FanofExcel18
Board Regular
- Joined
- Jun 7, 2018
- Messages
- 65
I'm attempting to do a conditional format based on a formula.
Row of data, B2:AC2
I would like to take the Average then have the cells highlight based less the Average. Lastly, I want to ignore 0.
Example: Average is 20
Anything less than 20 is highlighted and anything 0 is not highlighted.
=IF((AVERAGE(B$2:AC$2)<B$2:AC$2,5) -- This was my attempt but it doesn't work.
Appreciate any help.
Row of data, B2:AC2
I would like to take the Average then have the cells highlight based less the Average. Lastly, I want to ignore 0.
Example: Average is 20
Anything less than 20 is highlighted and anything 0 is not highlighted.
=IF((AVERAGE(B$2:AC$2)<B$2:AC$2,5) -- This was my attempt but it doesn't work.
Appreciate any help.