•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formatting for highlighting cells
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]
Want to read more?
Check out the full article on the original site