I have been working on excel worksheet where I need to get the cell value (in this case it is the date) from the adjacent column as well as highlight/background colour of the maximum value in column B. The max value changes based on the input in column.
I'm trying to create a excel worksheet that highlights by changing the background colour of the maximum value in the apple, Orange & Grape column . The max value changes based on the input in another column.
I had come across this formula =MAX(IF(NOT(ISNA(C2:C7)),C2:C7)) but I dont seem to be getting the desired answer.
Secondly, I need to get the date that corresponds with the maximum value that is located in the column to the left.
I was trying VLOOKUP but again not getting the desired answer.