not exactly what i was looking for. say i have q252 through q 2000 i want to
find and hightlight anything that is less than 8 same thing for r s and t

"Toppers" wrote:

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