Hello,
I have a large data 45900 rows and 5 columns of number. I want to find the biggest number in each row and highlight each of the number from highest to lowest. (with different colors)
Is there a way to do it? I can't attach the excel file because it is 1.9 MB and the system only allows 1 MB.
Thank you
Each cell needs 5 conditions, one for each colour
Determine your 5 colours from highest to lowest, e.g. RED (highest) to BLUE (lowest)
Select A1
Conditional Formatting
New Rule
Use a formula to determine...
=(RANK(A1,A1:E1)=1)
format as RED
=(RANK(A1,A1:E1)=2)
format as required
=(RANK(A1,A1:E1)=3)
format as required
=(RANK(A1,A1:E1)=4)
format as required
=(RANK(A1,A1:E1)=5)
format as BLUE
Use Format painter (paintbrush icon) to copy to other cells
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hello. Thank you for the answer. I did it, and the rule is applied only first row. I am trying format painter but it doesn't work. It swaps the number in the first row, when I drag it down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks