•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formatting for highlighting cells
Our take
Conditional formatting is a powerful feature in spreadsheets that can greatly enhance your data management experience. If you have lengthy columns, such as Column A and Column B, and you want to highlight cells in Column B that don’t match any content in Column A, you're in the right place. This process can seem daunting, especially with over 80 cells to check. However, with the right formula, you can efficiently identify discrepancies and streamline your workflow, making data analysis simpler and more intuitive.
I have two very lengthy columns, let’s call them column A and column B. I need to highlight all of the cells in column B whose content does not appear in column A, but there are 80+ cells I’d have to check and it’d take me a really long time. I’m in no way an expert on excel but I do know I’d have to use conditional formatting, I just don’t know how to build the formula for this :(
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Highlight non-adjacent cells that have same content in three columnsHave worksheet with several columns and multiple rows where need to highlight cells that have same data as in other rows. Basically, if column A, B and G have identical information in rows 7 and 183, these cells will all highlight. Goal is to identify if the same sequence of data is present, in another row of the worksheet. I have used following formula previously: =Countifs($A$7:$A$319,$A7,$B$7:$B$319,$B7)=1 However, I now need to innclude data that also appears same in column G. Note: the data in each column is different, Example: Row: 7: Column A: ABCD, Column B: 1234, Column G: Foxy Row: 183: Column A: ABCD, Column B: 1234, Column G: Foxy This match would highlight, but if one data point differs, no match. Hope someone can help here... Thank you. submitted by /u/ThunderWarrior3 [link] [comments]
- Conditional Formatting with another cell?Hi everyone! I'm trying to create a condition where depending on the value of two cells, it will change the fill of one of them. For example, If Cell A is < 10% AND Cell B is X, then Cell A will be green. If it is > 10% and Cell B is X, then Cell A is red. How would I go about doing this? submitted by /u/Educational-Bass-413 [link] [comments]
- How to "fact check" with conditional formatting?I'm sure it is a simple formula I'm missing, but I'd like to basically "fact check" in excel, using a formula and from there conditional formatting. Basically I have a type of schedule, and I want to make sure each column has at least 1 of certain text in it (to make sure all shifts are covered). So basically as long as Column A contains at least one instance of "A,B,C,D" etc, it is "True", and if not, false. Is there a way to do this? submitted by /u/Robot-duck [link] [comments]
- Conditional formatting based on a range of text in 2nd sheetHey! I have a two sheet workbook. First sheet has column A: list of order numbers that should be highlighted based on status and column B: status. the status text comes from a list in the second sheet. all possible statuses are listed from A1:A10 on the second sheet, but there might select colors per status (like from A1:A3 and A10 would all need the same color) Right now I have as a formula: =$B1='Sheet2!A1 and that works, but trying to use a range doesn't work =$B1='Sheet2!$A1:$A$5 I'm certain I'm overlooking a basic issue, but my googling skills are failing me 😞 submitted by /u/jaegerjockey [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#natural language processing for spreadsheets#generative AI for data analysis#rows.com#AI formula generation techniques#real-time data collaboration#real-time collaboration#formula generator#conditional formatting#highlighting cells#Excel#column A#column B#cells#content#formula#check#lengthy columns