I have an attendance spreadsheet where, if the current and prior two cells are blank, I want the current cell to be yellow. If the prior three and current cell are blank, the cell color is red. See the attached sample.
Is there a way to show that as a formula in conditional formatting?
Thanks!
KRD
Bookmarks