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<>"")
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<>"")
1. Thank those who have helped you by clicking the Star * below the post.
2. Please mark your post [SOLVED] if it has been answered satisfactorily.
Sincerely,
Farid
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks