Conditional Formating

[Albert Mulder]

I need to check to see if

E36:K44 = "X"

and if so change formating.

What is the formula to check the cells for an "X"

I used this to check if there is a "1"
=COUNTIF(E26:K26,1)>0

 

[ShaneDevenshire]

Hi Albert,

If you are talking about conditional formatting, not need for a formula.
Choose Format, Conditional Formating, leave Cell Value Is selected and choose
Equal to in the second drop down, and type X into the third box.

 

[Albert Mulder]

It is not just one cell I need to check. I need to check the cells E36:K44
and format cell C53 if any cell within E36:K44 Has a cell with and "X" in it.

I have done the same thing to check if there is a value of "1" in any of
them using this code.

=COUNTIF(E26:K26,1)>0

and yes I have to use code, there in nowhere for me to select other cell
than the one I am changing.

ANYONE?

 

[Norman Jones]

Hi Albert,

Try using the equivalent formula:

=COUNTIF(E36:K44,"X")>0