Hi, I want to highlight red any data that is below 1 in column L based on the information from K. In the screenshot I have just attached the column K has a blank. I had tried to use conditional formatting, but its not highlighting L10. I am not sure if the blank plays a role in this or my approach. How do I go about this?
please see my workbook attached.
Screenshot (10).png
Bookmarks