Mar 30 2021 12:17 PM
Hello
I need some help about the conditional formatting.
I setup a condition to highlight the row, but it does not work.
I even tried to apply only on one cell, it does not work either.
Could someone help me to let me know where I did wrong?
I appreciate for your help, thank you.
Regards,
YL
Mar 30 2021 12:55 PM
@Yifen1615 Try by removing the quotation marks around FALSE.
Mar 30 2021 01:28 PM
Hello Riny,
Thank you for replying.
Remove the quotation seems work partially. Because it will highlight blank row, but not all blank rows.
And if I add one more condition, it will stop working again.
Please advice, thank you.
Mar 30 2021 09:31 PM
Solution@Yifen1615 Tried to capture your requirement in an small example in the attached workbook. Perhaps you can apply it to your own.
Mar 31 2021 10:52 AM
Thanks a lot, Riny! I appreciate your help. ;)
Mar 30 2021 09:31 PM
Solution@Yifen1615 Tried to capture your requirement in an small example in the attached workbook. Perhaps you can apply it to your own.