I have a table in Excel In each row, I want to highlight the column corresponding to the maximum value in that row. For example, if I have this table:
0 1 2 3
4 5 3 5
8 9 3 4
I want to highlight in row 1, 5, row 2 and 9 in row 3.
How can I do this myself?
Thank you!
In Excel 2008, you can use conditional formatting in the Styles section of the Home tab "Highlight Cell Rule ", then select" More rules ... ". This opens the "New Formatting Rule" dialog, select "Format only based on the top or bottom location" then rank in "Top" 1 and uncheck% of the selected range box. Then click the format button to select the format you want.
If you want to be able to do it completely automatically, what you can do is record a macro that shows the actions described above repeat for all the rows in your table.
Comments
Post a Comment