SOLVED

Conditional Formatting doesn't work

New Contributor

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

Capture2.JPG

Capture.JPG

5 Replies

@Yifen1615 Try by removing the quotation marks around FALSE.

@Riny_van_Eekelen 

Hello Riny,

Thank you for replying. 

Remove the quotation seems work partially. Because it will highlight blank row, but not all blank rows.Capture3.JPG

And if I add one more condition, it will stop working again.

Capture1.JPG

Please advice, thank you.

best response confirmed by Yifen1615 (New Contributor)
Solution

@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 

Thanks a lot, Riny! I appreciate your help. 

@Yifen1615 You're welcome!