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.

Day 1	day2	day3	day 4	day5
1	1	1	1	1

<colgroup><col span="4"><col></colgroup><tbody>
</tbody>

 

[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