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