Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Downloads
- The history of the theory of beam bending - Part 1
- Frame Analysis with Excel 1 - Single beam
- Frame Analysis with Excel - 4, 2D frame analysis
- Contour plots with Excel and Matplotlib
- Function roots with the Inverse Quadratic Method
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads by category
- Using LINEST for non-linear curve fitting
Recent Comments
Tag Archives: conditional formatting
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