If any cells c16:n16 = 1 then change fill color of b16

[nsmjc]

I want to apply a conditional format to cell B16 to make the fill color change to another color.

I can make it happen if I just use one single reference such as C16 but then I would have to create a conditional reference for the rest of the cells D16:N16

What would the formula look like to change the color of the fill in cell B16 if any of the cells in range C16:N16 =1. It seems to me I need to be using an IF OR statement but I can't seem to get it to work.

Thanks for the Help

[Richard Buttrey]

Hi,

All you need do is create the CF with the formula

=C16=1

Then APPLY it to the range C16:N16

[nsmjc]

Hi,

All you need do is create the CF with the formula

=C16=1

Then APPLY it to the range C16:N16

That would work to change cells C16:N16 a different color what I need to do is change B16 another color if any cell in the range of C16:N16 =1

[Phuocam]

Formula for CF:

=COUNTIF($D16:$N16,1)

[nsmjc]

Formula for CF:

=COUNTIF($D16:$N16,1)

=COUNTIF($D16:$N16,1) did not workTried it with out $ also and no go.

[nsmjc]

=COUNTIF($D16:$N16,1) did not workTried it with out $ also and no go.

Sorry its time for me to stop working =COUNTIF($D16:$N16,1) Does work if your type it correctly

Thankyou for the help

[Richard Buttrey]

Hi

Try

=COUNTIF($D16:$N16,1)>=1