Big Bill
New Member
I have created some gradebooks for my teachers and I want them to be able to highlight a cell if a grade is missing. I only want the blank cells to format, turn yellow, when an assignment has been entered in row 1. I'm trying to create a formula that I can put into conditional formatting that basically says "If there is an assignment in B1, and cells B4:B24 are blank, change to yellow and insert text "mi" in the cell. If there is no assignment, then the cells remain blank, with no formatting." I know the solution is probably pretty simple, but I have spent way too much time on this so far. I'd like to do this without a macro if possible.
I have attached my workbook for reference.
Thanks.
I have attached my workbook for reference.
Thanks.