Help with formula for IF ANY

[Barry A&P]

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]

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