Need help writing formulas for conditional formatting

[tarmand]

Can someone tell me how to say the following each in a different formula?

If $j8 is null
If $j8 is not null and $N8 is between 90 and 94
If $j8 is not null and $N8 is between 95 and 99
If $j8 is not null and $N8 is 100 or greater

 

[VoG]

Try

=$j8=""

=and($j8<>"",$N8>=95,$N$8<=94)

=and($j8<>"",$N8>=90,$N$8<=99)

=and($j8<>"",$N8>=100)

 

[tarmand]

Thanks! I didn't know how to say between.

Do you know how to make this apply to a cell that has a vlookup value in it?

 

[VoG]

Those formulas should work with cells that contain VLOOKUPs

 

[tarmand]

Those formulas should work with cells that contain VLOOKUPs

Doesn't seem to be. I thought it was because it wasn't a hard value.

 

[VoG]

Try posting an example of what you have and what you hope to acchieve http://www.excel-jeanie-html.de/html/hlp_schnell_en.php