First off, I am not even sure if i worded my question correctly, so sorry if i have.
What i want to do is... have for cells b4:b7 to have on green cell for the highest value from h4:h7. I can do it singularly, but id like to know if there is some function im missing because this could buy me a lot of time.
For example is there a function to apply whatever cell is selected when copying conditional formatting? Or something along the lines of
If "greatest" h4:h7 then "format green"
Or can i do a condition from a condition? How would i put that in a problem?
Again I'm sorry if this is confusing, and im sure i can better word this, im just slightly frustrated.
I am rephrasing sit see whether it tells what you want
i have some entries (numbers) in B4 to BV7
I have some number H4 to H7 also
if any cells in B4 to B7 has got the maximum of H4:H7 it shd be colored green
if so try this macro
Sub test() Dim r As Range, c As Range, mmax As Double Set r = Range("B4:B7") mmax = WorksheetFunction.Max(Range("H4:H7")) r.Cells.Interior.ColorIndex = xlNone For Each c In r If c = mmax Then c.Interior.ColorIndex = 4 Next c End Sub