SOLVED

Conditional Formatiing

Iron Contributor

Hello Everyone, 

I want to highlight number which is greater than 1000 and ignore " - "

like -

Screenshot (619).png

 

So, what should we write formula in conditional formatting?

 

Please help..

 

Here is a attached file.

2 Replies
best response confirmed by Excel (Iron Contributor)
Solution

@Excel 

=AND(A1<>"-",A1>1000)

 

Thank you so much sir.
1 best response

Accepted Solutions
best response confirmed by Excel (Iron Contributor)
Solution

@Excel 

=AND(A1<>"-",A1>1000)

 

View solution in original post