Highlight Cell if any cells in row are empty

[sagewhite]

Hello, I have another project I'm working on that I'd like some help with

My associates have to report their sales per department from a list of different categories.
(Any associate names used within the document are made for this example)

Referencing the attached sheet:

A1:G5 is how the default table should appear

A9:G13 is how the table should appear when either some cells were not completely filled out, or they are filled out completely.
-> Notice A11 is highlighted light orange when C11 is left blank
-> Notice A13 is highlighted light blue when all cells are completely filled out

A16:G20 is how the table should appear when all cells are completely filled out.

Any help would be greatly appreciated!!!! Thanks!

[AliGW]

Orange rule:

=COUNT($B11:$F11)<COUNTA($B$9:$F$9)

Blue rule:

=COUNT($B11:$F11)=COUNTA($B$9:$F$9)

Applies to: =$A$11:$A$13

[Pete_UK]

Select all the cells in column A that you want this to apply to, from A3 downwards, and then give them all a background colour of light orange. Then, with the same cells selected, click on Conditional Formatting | New Rule | Use a formula... , then put this formula in the dialogue box which pops up:

=COUNT($B3:$G3)=6

Click on the Format button | Fill tab and choose light blue, then OK your way out. Conditional formatting takes precedent over the manual formatting, so as soon as all the cells are filled in with numbers the colour will change to pale blue.

Hope this helps.

Pete

[sagewhite]

As always, you're very knowledgeable. Thank you Ali.