How to highlight a cell with the value nearest to another cell?

[Metallicor]

In a column (B5:B15) I have different values and in cell A19 i type in value and I then want the cell in column B with the nearest value in A19 to light up with a green color. What do I do ?

[Zizi64]

Here is my sample file with a possible solution:
.
nearest.ods (11.6 KB)
.
See the Conditions of the applied Conditional Format feature in the cell range B3:B15.

[Metallicor]

I know how to highlight the cell but I want to be able to change the value in A19 and make the cell with the closest value in column B highlight

[Zizi64]

@Metallicor

I want to be able to change the value in A19 and make the cell with the closest value in column B highlight

Try to change the value in cell B19 BETWEEN the minimal and the maximal value of the cell range.

[Lupp]

@Metallicor: Don’t post images, but sample files.

[Metallicor]

Sethúsalán roknari.ods (19.2 KB)

[Zizi64]

A similar question:
.

Find nearest value in list

What do you mean by “list of P10:T620”? That’s a range with 5 columns. Did you consider if it is acceptable for you to get the result associated with one arbitrary occurrence (the one found) of probably many occurrences of the same “nearest value”? Or: Why should this not be an issue in your case? Can you assure that any value being “nearest” in your column P is associated with the same result found in column T? Or can you assure that all the values in column P are unique?

[Metallicor]

List of P10 ect. was just a formula I found online and tried to fit to my sheet

[Lupp]

See example. (The additional columns only try to ease the understanding.)
Adapt it to your needs.
disask101785EmphasizeNearestByCF.ods (26.5 KB)