| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting to highlight the lowest valid value
Cell A1 contains a "critical value". I want to format the range B1:B5 so that
one cell is highlighted - the cell with the value closest to, but not greater than, A1. E.g. if B1:B5 looks like this: ColB 3 9 <--- This should be highlighted when A1 = 14 16 <--- This should be highlighted when A1 = 16 58 <--- This should be highlighted when A1 = 30 100 Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting to highlight the lowest valid value
Nevermind this post; I figured it out. I could swear I had tried this formula
and it didn't work... I must have mistyped. =ROW()=MATCH($A$1,$B$1:$B$5) "PaladinWhite" wrote: Cell A1 contains a "critical value". I want to format the range B1:B5 so that one cell is highlighted - the cell with the value closest to, but not greater than, A1. E.g. if B1:B5 looks like this: ColB 3 9 <--- This should be highlighted when A1 = 14 16 <--- This should be highlighted when A1 = 16 58 <--- This should be highlighted when A1 = 30 100 Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlight the entire row or particular cell using conditional formatting | New Users to Excel | |||
| Conditional formatting for lowest number in a string | Excel Worksheet Functions | |||
| How do I highlight a cell using conditional formatting and dates | Excel Worksheet Functions | |||
| Conditional Formatting lowest # if it only appears once | Excel Worksheet Functions | |||
| Need conditional formatting formula to highlight top ten values i. | Excel Worksheet Functions | |||
Linear Mode
