need validation for the entire range

Hi!

Attached file applies conditional formatting to range C14:C24 as required by you to address concern.

Thanks,