Mark has attended:
Excel Intermediate course
Excel Advanced course
Excel Pivot Tables course
Excel
hiow can you create a conditional format that finds the average of each row and highlights in red those numbers above the avg.
RE: excel
Hi Mark,
Thank you for the forum question.
Please find attached workbook.
I have set up a tiny table as an example. I have created the rule with the formula =$E2>AVERAGE($E$2:$E$4)
I hope this is what you want.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector