Link to home
Start Free TrialLog in
Avatar of Andreamary
Andreamary

asked on

Excel formula to count number of cells with fill color that contain text, and number of cells with no fill that do not contain text

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)

Thanks,
Andrea
EE_ColorCells.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Andreamary
Andreamary

ASKER

Perfect! Thanks very much, Ejgil...

Andrea