Forum Discussion
Yifen1615
Mar 30, 2021Copper Contributor
Conditional Formatting doesn't work
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 ...
- Mar 31, 2021
Yifen1615 Tried to capture your requirement in an small example in the attached workbook. Perhaps you can apply it to your own.
Riny_van_Eekelen
Mar 30, 2021Platinum Contributor
Yifen1615 Try by removing the quotation marks around FALSE.
- Yifen1615Mar 30, 2021Copper Contributor
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.
- Riny_van_EekelenMar 31, 2021Platinum Contributor
Yifen1615 Tried to capture your requirement in an small example in the attached workbook. Perhaps you can apply it to your own.
- Yifen1615Mar 31, 2021Copper Contributor
Thanks a lot, Riny! I appreciate your help. 😉