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