View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Narnimar Narnimar is offline
external usenet poster
 
Posts: 132
Default 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?