Conditional Formatting Formula...

[wmitchell]

Hi,

I'm trying to create an If/Then conditional formula where I have three columns.

Column A = Purchase Order Number (inconsequential)

Column B = ETA Date

Column C = Percentage of PO received

I have a macro that highlights Column B, if they occur in the past. I would like to create a formula for Column C that will evaluate whether or not Column B is past due AND Column C is not equal to 100%. I've tried several times to create a formula that does not return accurate results.

I would like for Column C to shade in if the aforementioned statement is true.

Here's what I've tried and like I said, it does not return accurate results:
=IF(B64<TODAY(), AND(C64<100%))

Thanks for any help!

[oldchippy]

Try this

=IF(AND(B64<TODAY(),C64<100%))

[wmitchell]

Try this

=IF(AND(B64<TODAY(),C64<100%))

Small error, I think I got it to work with this:

=IF(AND(B62<TODAY()),C62<100%)

[oldchippy]

Glad you were able to sort it out - thanks for the feedback

[wmitchell]

Glad you were able to sort it out - thanks for the feedback

Thanks for your help

[Richy15]

Hi,

I'm sorry to ask this. I tried the following formula with my questionnaire results. I have five columns where in one column there is likely to be a "1".

I've tried to put this on a one to five scale so that it is easier to calculate the mean. That is, creating a new column that represents the score in each of the other five columns.

I used:

=IF(AND(A2=1,1)IF(B2=1,1*2)IF(C2=1,1*3)IF(D2=1,1*4)IF(E2=1, 1*5)))))

Have been trying to work this out all morning and seems to be made worse in that the computer i'm using is all in japanese... . Any advice would be very gratefully received.

[Richy15]

Hi,

I'm sorry to ask this. I tried the following formula with my questionnaire results. I have five columns where in one column there is likely to be a "1".

I've tried to put this on a one to five scale so that it is easier to calculate the mean. That is, creating a new column that represents the score in each of the other five columns.

I used:

=IF(AND(A2=1,1)IF(B2=1,1*2)IF(C2=1,1*3)IF(D2=1,1*4)IF(E2=1, 1*5)))))

Have been trying to work this out all morning and seems to be made worse in that the computer i'm using is all in japanese... . Any advice would be very gratefully received.