• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help with a formula through conditional formatting

DoubleD

New Member
I am self taught in the area of formulas and creating macros, but getting better. However, with no real education in these fields, I sometimes find myself creating more work for what most of you might find elementary... So here is my issue:
I have a percentage in column C and this is formulated based on figures in A and B. Simple math of B/A=C. However, I want to use conditional formatting to highlight the top 3 cells in C, but do not highlight if the figure in A is not greater than 75. Also, if possible, can I highlight these top 3 in different colors?
upload_2016-12-23_9-27-11.png
 
You'd need 3 different CFs.

=AND($C1=LARGE(IF($A$1:$A$8>75,$C$1:$C$8),1),$A1>75)

Is the CF formula for highest value in C, when A1>75.

You only need to change the number in red to 2 or 3 for 2nd and 3rd highest value.

See attached.

Edit: Note that this will not differentiate between ties.
 

Attachments

  • CF_RankCondition.xlsb
    8 KB · Views: 7
You'd need 3 different CFs.

=AND($C1=LARGE(IF($A$1:$A$8>75,$C$1:$C$8),1),$A1>75)

Is the CF formula for highest value in C, when A1>75.

You only need to change the number in red to 2 or 3 for 2nd and 3rd highest value.

See attached.

Edit: Note that this will not differentiate between ties.

Thank you kindly for your help!!!!
 
Back
Top