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)




Thank you so much sir.