yogi_Conditionally Format Unfilled Scores In Range F2:I

Google Spreadsheet   Post  #2316

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-11-2017

question by: Erin_Brady

https://productforums.google.com/forum/#!topic/docs/nrraFnBmbNA;context-place=forum/docs

If, and, then conditional formatting?

Hi all, 

I am somewhat of a novice looking for expert advice! 

I have a sheet where columns A-E contain student data and teachers add 4 points of data ('scores' if you like) in columns F-I. Last year, we had many teachers forget/ neglect/ overlook one or more of the 'score' columns so I wanted to add a formula where if one (or more) of the columns was blank, it would show up as bright yellow.

Problem is, I only want this for rows where student data is entered ie. not for rows where we wouldn't expect any data entry. 

I am thinking this is the worded version of what I want...

IF column B has an entry AND any of column F-I is blank THEN highlight the blank cell in bright yellow

but not sure what that looks like in terms of conditional formatting/ composing an actual formula.

Would appreciate any help that anyone has to offer.

Many thanks, Erin