need a code for max & min value code

[htm]

Need a VBA code to lookup for the max and min of each column , and then highlight the max with red and min with blue

 

[pecoflyer]

You don't need code for that, just use Conditional Formatting

 

[p45cal]

similar post at:

max and min values and change the currency

need a VBA code that look for the max and min cost and change the currency to SAR

www.vbaexpress.com