Jan 09 2020 03:11 AM - edited Jan 09 2020 03:14 AM
Jan 09 2020 04:26 AM
SolutionI guess that is since you have not blanks but cells with empty string ("") returned by formulas. Any text is always more than any number. You may apply conditional formatting rule with formula
=(A1>5000)*(A1<>"")
assuming your range is column A.
Jan 10 2020 08:31 AM
Nov 22 2020 04:16 PM
Nov 23 2020 12:12 AM
Values to the column are returned by formula, something like
=IF( condition, calculated number, "")
Thus there are no blank cells here, only numbers and cells with empty strings. If use in logical condition, any text is always more than any number. That means that ="">5000 returns TRUE. Not to color cells with empty strings we add (A1<>"") using AND condition.
Nov 23 2020 12:40 PM
Thanks a lot. Smart and interesting. :)
Jan 09 2020 04:26 AM
SolutionI guess that is since you have not blanks but cells with empty string ("") returned by formulas. Any text is always more than any number. You may apply conditional formatting rule with formula
=(A1>5000)*(A1<>"")
assuming your range is column A.