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
Last edited by DavidMakalu; 10-19-2019 at 01:44 PM.
Why do you have this in K10?
=""
Get rid of it.
CF rule: =$K4<1
Applies to: =$L$4:$L$10
Last edited by AliGW; 10-19-2019 at 01:26 PM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
That shouldnt be there I must have forgotten to remove it although I did use condition formatting without it at first. Otherwise K10 should be blank. I will try you advice right away.
.
It works.
Excel 2016 (Windows) 32 bit
Fluid flow Flow Index normal normal Turbulent Turbulent Turbulent normal normal
Sheet: Sheet2
Thanks Ali, the CF worked perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks