- Registration date
- Monday August 16, 2010
- Last seen
- June 17, 2021
Rahul, Good morning.
"...This may be because of NA is starting with N..."
Probably there is a wrong formula.
Try to do:
Suppose you want format A1:A10
--> Using formula --> =A1="N"
Choose desired format. Example: Fill GREEN
--> Using formula --> =A1="NA"
Choose desired format. Example: Fill RED
Please tell us if it worked for you.
I hope it helps.