Conditional Formatting to Make Highest/Lowest ID# Bold Based on Another Range

%3CLINGO-SUB%20id%3D%22lingo-sub-2613254%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20to%20Make%20Highest%2FLowest%20ID%23%20Bold%20Based%20on%20Another%20Range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2613254%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20a%20lot%20of%20difficulties%20trying%20to%20figure%20out%20the%20correct%20formula.%20I%20have%20to%20use%20conditional%20formatting%20to%20make%20the%20corresponding%20ID%23%20(column%20A)%20bold%2Fgreen%20based%20on%20the%20highest%20Actual%20Tax%20Owed%20(column%20F).%20And%20then%20make%20the%20corresponding%20ID%23%20bold%2Fred%20based%20on%20the%20lowest%20Actual%20Tax%20Owed.%20It%20has%20to%20be%20flexible%20in%20case%20the%20numbers%20in%20the%20Actual%20Tax%20Owed%20column%20change.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBased%20on%20Google%20searches%20I've%20tried%20the%20formulas%20%3D%24A%2416%3A%24A%2426%3DMAX(%24F%2416%3A%24F%2426)%3B%20%3D%24A%2416%3DMAX(%24F%2416%3A%24F%2426)%2C%20but%20nothing%20is%20working.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2613254%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2613552%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20to%20Make%20Highest%2FLowest%20ID%23%20Bold%20Based%20on%20Another%20Range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2613552%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1120891%22%20target%3D%22_blank%22%3E%40KCScott85%3C%2FA%3E%26nbsp%3BThe%20CF%20rule%20to%20highlight%20the%20ID%20with%20the%20highest%20Tax%20owed%20should%20be%3A%3C%2FP%3E%3CP%3E%3DF16%3DMAX(%24F%2416%3A%24F%2426)%20and%20apply%20it%20to%20the%20range%26nbsp%3B%24A%2416%3A%24A%2426%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ENote%20that%20there%20are%20no%20%24%20sign%20in%20the%20first%20F16%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EReplace%20MAX%20by%20MIN%20to%20highlight%20the%20ID%20with%20the%20lower%20amount.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2614794%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20to%20Make%20Highest%2FLowest%20ID%23%20Bold%20Based%20on%20Another%20Range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2614794%22%20slang%3D%22en-US%22%3ETHANK%20YOU!%3C%2FLINGO-BODY%3E
Occasional Contributor

I am having a lot of difficulties trying to figure out the correct formula. I have to use conditional formatting to make the corresponding ID# (column A) bold/green based on the highest Actual Tax Owed (column F). And then make the corresponding ID# bold/red based on the lowest Actual Tax Owed. It has to be flexible in case the numbers in the Actual Tax Owed column change.

 

Based on Google searches I've tried the formulas =$A$16:$A$26=MAX($F$16:$F$26); =$A$16=MAX($F$16:$F$26), but nothing is working.

2 Replies

@KScott85 The CF rule to highlight the ID with the highest Tax owed should be:

=F16=MAX($F$16:$F$26) and apply it to the range $A$16:$A$26

 

Note that there are no $ signs in the first "F16"

 

Replace MAX by MIN to highlight the ID with the lower amount.