CODEWITHSUNDEEP
excelvba
Dorbs
Dorbs

Reputation: 183

Set Column Colour based on top value in range

I have some conditional formatting that looks for the highest value in ($L$68:$V$68) and makes the highest valued cell pink.

What id like to do though, is make the whole COLUMN pink.

How would this be possible via VB or conditional formatting?

I was thinking along the lines of something like

localvariable = MAX($L$68:$V$68)

And then set left(localvariable,1) = chosen colour.

Upvotes: 2

Views: 50

Answers (1)

Isaac Moses
Isaac Moses

Reputation: 1609

Set a conditional format for the whole table (columns L through V) based on = L$68 = MAX($L$68:$V$68). The lack of a $ on the first column designator will make it evaluate the appropriate cell in Row 68 for each column when deciding whether to apply the format to that column.

Upvotes: 2

Related Questions