Is there an ANY formula for an excel Cell??

i want to set the conditional formatting for a range of cells in a excel
2007 column to the text "OFF" currently i have the formatting for each cell
in the range to highlight if the value contains "OFF"

i would like to have the entire range of cells highlighted if ANY of the
cells in the range contain "OFF"

Am i nuts or is this possible??

Thanks for your help

Select your range (say C7:e9)
Then use formula is:
=countif($c$7:$e$9,"off")>0
And apply the format you like.

Barry A&P wrote:
>
> Is there an ANY formula for an excel Cell??
>
> i want to set the conditional formatting for a range of cells in a excel
> 2007 column to the text "OFF" currently i have the formatting for each cell
> in the range to highlight if the value contains "OFF"
>
> i would like to have the entire range of cells highlighted if ANY of the
> cells in the range contain "OFF"
>
> Am i nuts or is this possible??
>
> Thanks for your help

--

Dave Peterson