Help with formula for IF ANY

  • Thread starter Thread starter Barry A&P
  • Start date Start date
B

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