how to insert conditional formatting based on multiple cells

[janichohan]

can anyone help me ... i want to insert formula in a cell base on


i have 5 cells and in 6th cell i want to insert formula which tells me if min 3 cells (based on 5 cells) had value "1 " it flag true or color the cell green else red.

[TABLE="width: 358"]
<colgroup><col span="4"><col></colgroup><tbody>[TR]
[TD]Day 1[/TD]
[TD]day2[/TD]
[TD]day3 [/TD]
[TD]day 4[/TD]
[TD]day5[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

 

[DRSteele]

With your data in A1 to E2, put this into F2 =COUNTIF(A2:E2,"=1")>=3

Format the F2 cell with red fill.

Then invoke the Conditional Formatting process and elect New Rule, then Use a Formula and put this exactly in the Format Values box =COUNTIF(A2:E2,"=1")>=3 and format with green fill.

 

[janichohan]

thanks alot brother