Hi,

Anyone please help me.

I want to change font color to red if cells value not blanks and less than 3.00.

However it seems the array set does not work =AND($J$2:$J$193<2.995,$J$2:$J$193<>"")