Hello All,
I have two ranges B3:Y3 and AC3:AZ3 and all the values in the first range are zero but i still want to select the cell with conditional formatting which corresponds to the formula
=CELL("address",INDEX($B3:$Y3,MATCH(MAX($AC3:$AZ3),$AC3:$AZ3,0))
How can i do that?Any ideas?
Thank you in advance
Bookmarks