Aug 04 2022 07:14 AM
Hello Experts,
I am creating an excel sheet where user will have to put values with 4 decimal places. The value will turn red if it does not have four decimal places (i.e. more or less decimals places). I formatted the cells as number with four decimals and red font, so all input values become red (regardless of decimals places). Then, I applied the conditional formatting with formula =LEN($D6&"")-FIND(".",$D6&"")=4, and conditional formatted the font black, so all input values with four decimals turn black. Everything works fine till this stage.
I have an issue while I put value with four decimals places, but zero at fourth decimal place (e.g. 1.1110). The excel doesn't consider trailing zero at a decimal, and doesn't convert the value to black. I am sure I am missing something here.
Your support will be highly appreciated.
Thanks in advance!!
Aug 04 2022 08:11 AM
Aug 04 2022 09:29 AM
Aug 05 2022 03:50 PM
Aug 05 2022 06:49 PM