How to highlight all cells of the same value in a column when a specific text is in another column
Hi I'm trying to use either VBA or conditional formatting for this but it doesn't work the way I want it to :/
Column B is a list of values that are keyed in by different people one at a time, column C is the status of the person. What I'm trying to achieve: ONLY when column C is "OUT", the value in the adjacent cell (in column B) is shaded and all the same values of that cell is shaded as well.
I can shade the column B cell given "OUT" in column C but I can't get all the same values before that to be shaded as well. There are 3 possible status: NEW, AFTERNOON, OUT
Anyone have any ideas please? I attached a photo I hope it explains abit clearer
Is there a way to highlight more than 2 cells? If I have 3 of same value, only the last 2 duplicates will be highlighted – geravie498 5 hours ago
In such a case you only need one rule.
Let's assume the data is in B1:C10. Adapt the formula accordingly.
Match all the value of B1 in the range below where $B$1:$B$10=$B1 and $C$1:$C$10="OUT"
RULE
=INDEX($B$1:$B$10,MATCH(1,($B$1:$B$10=$B1)*($C$1:$C$10="OUT"),0))
- Putting Textboxes into array for formatting
- Code inserting and copying to the wrong worksheet
- convert a C# datetime object into Excel date format
- Get values from available column in a row to the first column of the same row
- VBA - Worksheet.activate not working
- Transform datatable from column-based to row-based
- Check for consecutive characters in an excel cell
- Add text to first available cell in range with non-contiguous cells
- Data Entry Transfer to Multiples Tables to Specific Sheets
- ExcelScript fails on webapp, succeeds on desktop
- Is there is Limition of using opencsv API or Apache Poi Api?
- How can I merge one excel datasheet with a master excel sheet with only some columns matching?
- How to access textBox placed on sheet in VBA module?
- Looking to create a copy of a document and copy data from Excel (words and tables) into it at bookmarks
- Only loop selected rows in Excel VBA
- How to pass multiple Excel sheets as data table when using ExcelDataReader?
- Combine most recent 5 records into one cell in Excel
- AutoFilter returning to 1st Range when trying to apply filter to different Range
- Importing Excel-tables in R
- Using Python, how to update an excel sheet on Azure Blob Storage while maintaining existing data in the sheet?
- Reorder sheet names in custom order
- Dynamic array using xlwings causing formula to be wrapped with {}
- Matching multiple number rows and check corresponding dates within 90 days
- Sum all cells for which corresponding cell is not a formula and doesn't return #VALUE AND date occurs in the past
- How can I use countif to return only a count if sum is > 0 but only count it once
- excel No of hours in a shift
- How to split a string into a 2-dimensional array in vba?
- Filter Range C3:G3 And paste to other cells
- How to solve Excel VBA: Compile error in hidden module
- Conditional Format Cells with Special Characters including Accented Letters, Numbers, and Punctuation