Conditional formatting with many if's and ands, etc.

[yybb44]

Hello All,
I don't even know if this is possible... I'm on Excel 2000.
Here is the image link:

http://img84.imageshack.us/my.php?image=examplelw7.jpg

What I want to accomplish:

When the number in Columns B and D are above the "Goal" number in row 8 for each individual column...highlight in blue.

BUT only if the letters in columns C and E are not "U, UJ, NJ, or JN"
Only highlight numbers that are attached to no letter at all or a J.

While we are at it....also if the numbers in Columns B and D are above the "Background" number in row 9 for each individual column...highlight the text in red.
and also if only the letters in columns C and E are not "U, UJ, NJ, or JN"
Only highlight numbers that are attached to no letter at all or a J.

Thank you in advance!!

 

[yybb44]

oops....one more thing. What if one of the cells isn't a number. Let's say it's a "--"....how can I stop it from highlighting it?? Thanks again

 

[Gerald Higgins]

When I try this, cells containing "--" aren't highlighted in the CF colours.
Are they highlighted in your version ?

 

[yybb44]

I was experimenting with a couple of tables I use and -- were being highlighted...but I just played around with it and got it to work...

I added IF(ISNUMBER(B2) to the beginning of the formulas

Thanks again