I have a range A1:A20. Each cell in this range contains a number between 1 and 100. I'd like to be able to format this range so that the top 3 or largest 3 numbers appear in red. Is there a way to do this? Thanks!
I have a range A1:A20. Each cell in this range contains a number between 1 and 100. I'd like to be able to format this range so that the top 3 or largest 3 numbers appear in red. Is there a way to do this? Thanks!
I'm not sure how to do this with 1 condition, but here is how to do it with 3 (Formula Is):
=A1=LARGE($A$1:$A$20,1)
=A1=LARGE($A$1:$A$20,2)
=A1=LARGE($A$1:$A$20,3)
Tried those conditions but that just turned the number in A1 red.
Try
=RANK(A1,$A$1:$A$100)<=3
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Select the column first before applying the CF
VBA Noob
That still only formats the 1st cell in the range. The format that I'd like to apply is to change the color of the the 3 largest numbers in the range A1:A20 to red. Thanks
Select cell A1. Then hold down SHIFT and CTRL and hit the down arrow. This will highlight A1:A20, with A1 as the active cell. Now go to conditional formatting and use VBA Noob's formula above.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks