HR Analyst

how do I write the following formula:  cell A1=25, look at range A5 through A8 and highlight the cell value closet to A1?  Possible with a conditional format or do I need to use an IF statement???  I have tried both and easy enough to find a mix, max value but having a hard time with this one.  I know for the below listed example the answer should be cell A5 but I am dealing with hundreds of rows of data and I don’t want to have to write numerous formulas for each cell reference.

 

A1=25

A5=29

A6=35

A7=40

A8=90

Leave a Reply

Your email address will not be published. Required fields are marked *