Excel: Conditional formatting

Resolved · Medium Priority · Version 2016 (Mac)

Tue 27 Feb 2018, 13:32 Delegate Alexandra said...

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.

Tue 27 Feb 2018, 14:33 Trainer Sarah said...

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