Jun 19 2022 11:41 PM
Hello Everyone,
I want to highlight number which is greater than 1000 and ignore " - "
like -
So, what should we write formula in conditional formatting?
Please help..
Here is a attached file.
View best response
Jun 20 2022 12:41 AM
@Excel
=AND(A1<>"-",A1>1000)
Jun 20 2022 05:26 AM