Formula range based on highlighted selection

[Kyoukami]

Hi,

I use this macro to highlight the lowest value cell of each row, to show me which number value is the lowest per row at a glance.

I want to automate this line based on my highlight selection instead of manually changing it each time.

Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=B2=MIN($B2:$E2)" <-------- (B2 is the first cell, most top left) and (E2 is the most top right cell) out of my highlighted range.


Basically to use this macro i highlight box all the cells and click this macro.
It does what this page does except with 1 click on the macro https://www.extendoffice.com/documen...ow-column.html

Please Login or Register  to view this content.

[Richard Buttrey]

Why do you need a macro? Why not have the conditional format held permanently for all the rows you are evel likely to need?

[xlnitwit]

Hi,

This should work for your selection

Please Login or Register  to view this content.

[Kyoukami]

I constantly create new workbooks and often use this set of conditional format and i can't seem to create a rule that stay permanent on new workbooks i create.

Thank you xlnitwit, it works exactly how i wanted it.