New answers tagged

0 votes

Excel: How to highlight value if greater than or less than previous column/row's last non-blank value

You want to find the last non-blank in column L above the current row? Here's the formula you would put in row 2: =LOOKUP(2,1/($L$1:$L1<>""),$L$1:$L1) Note that the first $L$1 is ...
-2 votes

Mass edit of Excel conditional format structure with formulas. Used the year 2022 in the formulas and need to change for 2023

For future spreadsheets that YOU build (not much direct help for those someone else builds), you can always put such things into Named Ranges and use the Named Range in the Conditional Formatting ...
  • 26
1 vote
Accepted

Mass edit of Excel conditional format structure with formulas. Used the year 2022 in the formulas and need to change for 2023

There is a VBA solution. This will change it for the active sheet: Sub ChangeYearTo2023() Dim cf As FormatCondition For Each cf In ActiveSheet.Cells.FormatConditions cf.Formula1 = ...

Top 50 recent answers are included