With Format==Conditional Formatting, select column (E in my example) and do

Set Formula is:

=AND(E1<"",E1<8)

This will ignore empty cells

HTH

"orm" wrote:

i need a formual to highlight anything under 8 i have been trying to figure
it out but it's just not clicking anyone know a solution