If Statement help

[dchaney]

I ran a search and did not find anything on my question, so I appoligize if it has already been posted.

Here is what I am trying to do, I have a spreadsheet that has 11 columns, what I need to do is look at cell C3 and then at Column G, if C3 = Packaging and any cell in column G does NOT = EFLS, ENVS OR ESAA highlight it Red with White text.

Right now the formula I am using is looking at Cell C3 and then G5 and if C3 is Pacakaging and G5 is EPT it highlights.

Basicly I need the code to look at C3 and column G (could be 1000+ rows) if C3 is Packaging and the cell in column G is NOT EFLS, ENVS OR ESAA I want it to highlight the cell red with white lettering..

Thgis is what I have: =IF(AND($C$3="Packaging",G5="EPT",G5="ECT"),TRUE,FALSE)

 

[mvptomlinson]

Perhaps try:

=AND($C$3="Packaging",AND(G5<>"EFLS",G5<>"ENVS",G5<>"ESAA"))

 

[dchaney]

Thanks A Lot!!! Exactly what I was looking for, your the best!!!