Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Cubic Splines
- XLDennis, the MSDN Library, and VBA rant
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Linking Excel to C - 2
- Writing Arrays to the worksheet - VBA function
- Intersections, interpolations, and rotations
- Non linear regression – 2; ALGLIB functions
- Continuous Beam spreadsheet with moving load
- Drawing in Excel 8 - scaling and trimming
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