Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- About Newton Excel Bach
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Downloads
- Frame Analysis with Excel - 3, Continuous beam or frame
- Intersections, interpolations, and rotations
- Filling Blanks with Go To-Special (and local help rant)
- Daily Download 2: SLS design of reinforced concrete sections ...
- Latex Maths Text in Excel
Recent Comments

Z on Downloads py_xlCBA – Sup… on py_xlCBA update 
dougaj4 on Downloads 
Z on Downloads py_xlCBA update | Ne… on Calling PyCBA from Excel 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
khoitsma on Continuous beam animations wit… 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC…
Tag Archives: Office Insider
Using conditional formatting with array formulas
A recent Quora question asked “How do I highlight the number closest to an initial number in a row in Excel?“. The answer by Bill Jelen provides a good example of using conditional formatting with an array formula: In my … Continue reading
Posted in Arrays, Excel
Tagged Array Formula, conditional formatting, Excel, Office Insider
Leave a comment