Conditional Formatting OR Expression??

[SMac]

I am using all 3 conditions so is there a way to combine these 2 lines of
code into 1 condition? They both result in turning the cell red:

'(this line looks to see if there is a percent other than 0 or 100 and
calculates the percent where we should be versus the actual, cell H33)
=IF(AND(H33>0%,H33<100%),(H33<=((H32-$C$2)/$H$8)))
OR
=IF(H33=0%,(H32-$C$2)<$H$8)
'(this line looks to see if there are still enough days to complete)

Cell H33 is a % Comp, H32 is End Date, $C$2 is Today's Date and $H$8 is #
days to complete, just FYI.

THANKS!!
Stacey

 

[Bob Phillips]

Do an OR

=OR(cond1,cond2)

 

[SMac]

I am not sure how to combine them, how would that look?

 

[Dave Peterson]

It looks like this might work (well, to me!):

=OR(AND(H33>0%,H33<100%),AND(H33=0%,(H32-$C$2)<$H$8))