excelexcel-formulaconditional-formatting
Conditional format if consective cells in a column contain certain text
I'd like to do conditional formatting on column A if consecutive cells in the column contain the text "Grade". In the picture below, only A6 should be highlighted.I tried this
=AND(NOT(ISBLANK(OFFSET(A5,-1,0))),ISBLANK(A5)
but it only highlights after a cell that isn't blank. One caveat is that all the cells have a formula to determine if there is a Grade or not, so they will not really be blank.
Solution
Use a rule based on the formula =ISNUMBER(SEARCH("Grade",A1)*SEARCH("Grade",A2)), applying it to cells A2:A11.
- Reporting Services export to Excel causes 'Repair' and removes styles
- Excel VBA macro to group rows based on condition
- Convert table to reflect column names as row values
- Combined two arrays and the result returned has an empty key and value
- VBA: ListBox Change event firing twice
- Excel VBA offset without activating the cell
- How to have instructional text in Excel?
- Creating a dymamic array which sums different columns depending on row
- How to copy a range to several worksheets by using a list of worksheets to copy to
- Excel's fullname property with OneDrive
- Why I can't compare two dates using comparison symbols in Excel?
- If certain columns are empty within a range, delete entire row (Excel macro)
- Is it possible to create a dymamic array which sums different columns depending on row?
- PowerPivot extract text after different characters
- Merging columns by looping
- Using VBA to copy and paste values into new workbooks but it's hardcoding original workbook at end of process
- Copying data into a worksheet when the destination has hidden rows
- Is it possible disable the "Go to location" feature when co-authoring in excel?
- writing multiple data frames into the same excel file in R
- XLOOKUP with flexible column for return_array and lookup_array
- When Converting excel to csv for empty cells quotes not coming
- Error in including wxAutoExcel in wxWidgets project
- Excel cell not updated correctly
- Convert Range to a table
- Convert number in excel to M or B
- How to change the subtotal or grand total formula in Pivot Table
- Excel LET Formula Results in #CALC! Error When Applying a Filter
- Save excel file using savefiledialog class in C#
- Excel right click add menu item issue
- Excel, generate a list of names depending on row and column values of another sheet