dineshchaure26
New Member
- Joined
- May 16, 2012
- Messages
- 3
In column A, suppose I have the below values
100.456
100.789
101.000
101.245
101.675
Now I want to use a formula that will highlight the immediate highest and lowest values from the column for a given number.
For example if the number that needs to searched is 100.987, then 100.789 and 101.000 must highlight since 100.987 falls between these two numbers in the column.
Please help me with the formula that I can use in conditional formatting.
100.456
100.789
101.000
101.245
101.675
Now I want to use a formula that will highlight the immediate highest and lowest values from the column for a given number.
For example if the number that needs to searched is 100.987, then 100.789 and 101.000 must highlight since 100.987 falls between these two numbers in the column.
Please help me with the formula that I can use in conditional formatting.