Conditional Formatting By Rule

[pickslides]

I have a cell I want to format. The cell is the sum of six cells.

I have three types of formatting depending on the count of the six cells.

1) Format type 1 if all six cells are populated

2) Format type 2 if only five cells are populated

3) No format if the count of cells is between 0 & 4.

Hope this is clear..

MQ

[allenz0rz]

To count nonblank cells, you can use the COUNTA function.

Please Login or Register  to view this content.

[FDibbins]

There is no need for VBA on this, regular Conditional Formatting will do the job. You did not specify the cells, so assume A1:A6...

1. highlight the range you want to apply the conditional formatting to (A1:A6)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =COUNTA($A1:$A6)=6................apply color (format fill) as required

Repeat 3 & 4 with...
=AND(COUNTA($A1:$A6)<6,COUNTA($A1:$A6)>4)

Rinse and repeat with...
=COUNTA($A1:$A6)<4

[MarvinP]

Hi pickslides,

I always like to have a sample workbook to see how it all works, so here is your answer attached.