Forum

Hi Sunny, Thank you for the tip, but unfortunately it doesn't work, because I need the condition for the "<5,0", and that is interpreted as text...

Hi, Sorry for answering late, I had to deal with other things... Thank you for all answers, both versions worked (unticking the ignore blank opt...

You can see at F5 Go to special --> Data validation. It is in the range AM8:BX4000 The formula I used is =IF(ISNUMBER(AM8);IF(AM8>=AM$4;TRUE;...