| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight the cell based on the range for a given value
I have a table for fee selector like this. I need to highlight the fees cell
based on the from - to range for a given value, say 65000.00 FROM TO FEES £1.00 £2,737.00 £41.00 £2,738.00 £8,212.00 £82.00 £8,213.00 £16,424.00 £164.00 £16,425.00 £24,637.00 £218.00 £24,638.00 £41,062.00 £274.00 £41,063.00 £68,436.00 £356.00 £68,437.00 £136,873.00 £411.00 £136,874.00 £273,747.00 £547.00 £273,748.00 £547,495.00 £821.00 £547,496.00 ABOVE 0.20% How to do it in conditional formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| VLOOKUP - unable to highlight cell range | Excel Worksheet Functions | |||
| Can't highlight a single cell. Creates a range when I move curso | Excel Worksheet Functions | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
| highlight range if cell contains desired data | New Users to Excel | |||
Threaded Mode
