With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, December 11, 2017
yogi_Conditionally Format Unfilled Scores In Range F2:I
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.