I'm trying to create a rule for conditional formatting for a range of cells from Column A and Column D through G.
If there is anything in Column B for that row AND that cell is blank I would like it highlighted. The problem I've been having while googling for the answer, is I'm getting confused with LENS, a lot of AND, and IF operations I don't think are necessary. The other problem I'm having is all of the 'solutions' I've seen only wants to work for a single column, say between B and just A. If there are gaps in some of the information, I only want those particular cells highlighted basically if they are missing information.
Attaching a pic of what I'm trying to do, hope it helps.
Bookmarks