Array set for Conditional Formatting

Originally Posted by Faridwahidi

=AND($J$2:$J$193<3,$J$2:$J$193<>"")

With that formula EVERY cell within the range would have to be a number <3.

It's evaluating ALL cells as a group when you need to evaluate EACH individual cell.