need validation for the entire range

Hi!

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

Thanks,

The formula used in conditional formatting is as under:

C14<>TEXT(B14,"0.0000"), then format.