Conditional formatting

[chahine]

Hello guys

i have strange result from conditional formatting, i put a conditional formatting for a cell to have green color when cell value is >60, but even if i put any text it gives green value something is strange

I attached a photo for my issue, it is cell F5 and it contains IF function, IF evaluates to true or false so it should not be green color

[#2 · Accepted solution]

@chahine 

Excel treats all text values as greater than all number values.

Change the rule as follows (I will assume that B5 is the active cell within the selection when you edit it):

• Select 'Use a formula to determine which cells to format.
• Enter the following formula in the box:

=AND(ISNUMBER(B5),B5>=60)

[#3]

@Hans Vogelaar Thanks Hans, new tip for me that text is greater than number :)

[#4]

Good idea Hans, Thanks