Aug 04 2021 07:29 PM
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.
Aug 04 2021 09:48 PM - edited Aug 04 2021 09:48 PM
Solution@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.
Aug 05 2021 04:07 AM
Aug 04 2021 09:48 PM - edited Aug 04 2021 09:48 PM
Solution@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.