Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2010

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

Attached files...

condiFormat average.xlsx

Fri 28 Aug 2015: Automatically marked as resolved.

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.