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

excel conditional formatting

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel: Conditional formatting

Excel: Conditional formatting

ResolvedVersion 2016 (Mac)

Alexandra has attended:
Excel Advanced course

Excel: Conditional formatting

Is it possible to apply conditional formatting per individual row without doing it manually each time (I have 1200 rows of data). Applying to the whole sheet takes into account the highest value of the whole sheet which isn't necessarily applicable to each individual row.

Hope you can help.

RE: Excel: Conditional formatting

Hi Alexandra,

You will need to create a rule using a formula.

Select your first row and go to Conditional Formatting>New Rule>Use a formula to determine which cells to format.

Use the formula:

=A1=MAX($A1:$D1)

(where A1 is the first cell in your row, and D1 is the last cell in your row)

Then use the format painter to copy the formatting to all the remaining rows.

This should save you a lot of time.

Regards,

Sarah
Excel Trainer

Tue 6 Mar 2018: Automatically marked as resolved.

Excel tip:

Adding multiple rows in an Excel 2010 Worksheet

If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet.

Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.

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.13 secs.