New answers tagged conditional-formatting
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 ...
- 4,761
-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 = ...
- 4,761
Top 50 recent answers are included
Related Tags
conditional-formatting × 781microsoft-excel × 612
worksheet-function × 167
microsoft-excel-2010 × 108
microsoft-excel-2007 × 59
microsoft-excel-2013 × 44
microsoft-excel-2016 × 44
vba × 35
formatting × 29
colors × 19
libreoffice-calc × 18
macros × 15
pivot-table × 15
spreadsheet × 14
google-spreadsheets × 14
cell-format × 14
microsoft-outlook × 11
calendar × 11
highlighting × 11
libreoffice × 10
microsoft-word × 8
openoffice-calc × 8
charts × 7
vlookup × 7
duplicate × 7