Conditional Formatting Formula

[Canadian911Guy]

Hello,

I am trying to write a conditional formatting formula for the attached sheet.
What I need to happen is this:

CELL I46 will turn red and in yellow text say "SEND TO HOSPITAL"
IF
CELL J47 is less than 25
OR
IF
There are two (2) or more symptoms selected in Section VIII
OR
IF
There is one (1) symptom selected in Section VIII AND one (1) abnormal selected in Section XI

Hope that makes sense. I've tried nested IF statements, I've tried with various forms of OR and AND, I can't seem to figure out the right combination.

100 Karma for your help!

[63falcondude]

CELL I46 will turn red and in yellow text say "SEND TO HOSPITAL"

You have cells H46 through K46 merged. That merged area would be referred to as H46.
Because of the merge, there is no I46.

Assuming that you meant H46, try this:

H46 =IF(OR($J47<25,COUNTA($E20:$E24)+COUNTA($I20:$I24)>=2,AND(COUNTA($E20:$E24)+COUNTA($I20:$I24)=1,COUNTIF($G35:$K38,"Abnormal")=1)),"SEND TO HOSPITAL","")

Select H46 > Conditional Formatting > New Rule > Use a formula

=OR($J47<25,COUNTA($E20:$E24)+COUNTA($I20:$I24)>=2,AND(COUNTA($E20:$E24)+COUNTA($I20:$I24)=1,COUNTIF($G35:$K38,"Abnormal")=1))

Format: Fill red, Font yellow > OK > OK

[JohnTopley]

Formula in H46 (merged cell)

=IF(OR(J47<25,COUNTIF($E$20:$E$24,"X")+COUNTIF($I$20:$I$24,"X")>2,AND(COUNTIF($E$20:$E$24,"X")+COUNTIF($I$20:$I$24,"X")=1,COUNTIF($G$35:$K$38,"Abnormal")=1)),"SEND TO HOSPITAL","")

in Conditional formatting

=$H$6="SEND TO HOSPITAL"

FILL: Red

Font: Yellow

[63falcondude]

Wow... duh. I did the CF formula before the cell formula and didn't even think to refer to the result of the cell formula.

O.P., I would use the CF rule in post #3 over mine.

... and i misspelled hospital... long week.

[Canadian911Guy]

THANK YOU BOTH!

I took pieces from each and got it to work. I've attached the final result.

100 Karma for you both!

[63falcondude]

You're welcome. Glad we could help.