SOLVED

Conditional Formatiing

Super 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 Zan (Super Contributor)
Solution

@Zan 

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

 

Thank you so much sir.