The attached spreadsheet uses conditional formatting to guide the data entry clerk in filling it out properly.
Column H and Column I have conditional formatting as follows:
If Column F includes the word 'YES', then all subsequent columns should be completed (cells have no fill color)
If Column F includes the word 'NO', then conditional formatting then changes cell color in Col H and I to orange, indicating to the user that these cells should not be filled out.
At the end of the production cycle, I would like to review the data entry for errrors. Specifically:
Col H and Col I:
# of cells with no fill color that are blank (formula result should be 4 cells in Col H, 3 cells in Col I)
# of cells with fill color that are not blank (formula result should be 2 cells in Col H, 1 cell in Col I)