Excel - Highlight rows based on set conditions
Is it possible to highlight rows where the employee Number is the same, but has more than one Job Name and at least one of those Job Names has to contain the word "Manager"? So in the case below, The employee number 12 rows would be highlighted because it has more than one Job Name and one of those Job names contains the word "Manager". Would something like this be done in VBA, Conditional Formatting, Formulas, or any other methods?
Solution
You can use Conditional Formatting. Assuming that your data is in cells A1:D11, highlight the whole column A, go to Conditional Formatting > New Rule > Use a formula to determine which cells to format:
=COUNTIFS($A$2:$A$11,$A1,$D$2:$D$11,"*manager*")
Hope it helps.
- Convert Range to a table
- In Excel, I wonder that how to use VLOOKUP function in OR logic
- Simple VBA array join not working
- Excel Pivot Table - Turn two columns with same values into a matrix pivot table with column names as rows and value count in columns
- Excel: Transforming automatically a cell based on the input in another one
- Check Duplicate Data
- Finding hidden or system files containing ~ using Dir() in VBA
- Deleting rows that do not have specific value (text) - throwing Error Code 13
- Filter function Delivers the Blank cells in the Array as Zeros and Other Blank cells in time formated cells as 12:00
- How to disable Excel's automatic cell reference change after copy/paste?
- Retrieve article name and store of cheapest article for a given category in Excel
- Filter function or alternative for Vertical and Horizontal Criteria
- Calculate SUMPRODUCT with multiple column criteria and one row criteria
- Format smallest value in range of same category in Excel
- Calculate SUMPRODUCT with multiple column criteria and one row criteria (with empty columns in the data range)
- How to group an array of shapes
- Extract text after last delimiter but exclude last character
- How do i calculate difference between counts for each value in Excel
- Highlight cell in a range if the cell value is same as the cell value in a column A
- How to count specific values between other values
- Excel Chart: color data labels by categories - rows
- Get table dynamically with name in excel
- Excel Chart: color data labels by categories - columns
- VBA Error 1004 occurs when manipulating a table
- Store location of cell and loop recursively
- Excel - 3D interpolation
- Excel Data Validation with XLOOKUP
- Using a list (range) of column critiera (not single cells) in FILTER formula
- Yield to maturity / IRR in Power Query M
- How to convert a worksheet to a Data frame in Pandas?