Conditional Formatting based on few columns

[VKS]

Dear Experts,

My workbook has 30 sheets and each sheet has aprox 150 rows. I am trying to find if value in column D is the lowest or the highest in comparison to values in column M, P, S, V or Y.

If value in column D is lower than Column M or P or S or V or Y then font in D is BOLD GREEN and if value in column D is higher than Column M or P
or S or V or Y then font is BOLD RED.

If value in D is not highest or lowest then do nothing.

Please advise.

Best Regards/VKS

[ursanil]

please provide a sample file and your required output