Excel 2007: Conditional formatting

  • Thread starter Thread starter Sven Berg
  • Start date Start date
S

Sven Berg

In Excel 2007, I want to create a rule that turns cells red in case
that 3 out of 7 cells in a column equal 0. What formula will catch
this condition? Thanks to the math stars! Sven
 
I did this with A1:G1
Selected the range; used Conditional Formatting on the Home group ->New
Rule ->Use a formula ...... and entered this
=COUNT($A$1:$G$1,0)>=3
When three or more cells in the range are zero (blanks do not count as zero
here), all cells go red
best wishes from Canada
 
I did this with A1:G1
Selected the range;
used Conditional Formatting on the Home group ->New Rule ->Use a formula ......
and entered this
=COUNT($A$1:$G$1,0)>=3
Click to expand...
Many thanks, now I understand the logic how to procede. For future
work, I'd best buy a manual.

Remaining problem was: After endless failures, I replaced the comma
between range and condition by a semicolon, then it worked perfectly.
Is there a way to customize the use of comma/semicolon, e.g. in
language options? Thanks again, best regards to beautiful Canada, Sven
 
Sven

Most European language settings default to the list separator of semi-colon.

You can change this in Regional and Language Options at Regional
Options>Customize.

In "List Sepatator" dialog change to comma.


Gord Dibben MS Excel MVP
 
Most European language settings default to the list separator of semi-colon.
You can change this in Regional and Language Options at Regional
Options>Customize. In "List Sepatator" dialog change to comma.
Click to expand...
Found. Done. Perfect!
Many thanks again, Sven
 
Back
Top