Conditional Formatting Closed

Question

Hello, 

Want to apply conditional formatting for specific text but not able to do so.

Below is the case:-

I have two texts - 1. "N" & 2. "NA"

I have applied a conditional formatting for N but it is automatically getting applied for NA. This may be because of NA is starting with N.


Please help me to apply different conditional formatting for "N" & "NA". 


Configuration: Windows XP / Firefox 45.0

Mazzaropi · Answer

Rahul, Good morning. 

"...This may be because of NA is starting with N..."
 NO.
Probably there is a wrong formula.

Try to do:
Suppose you want format A1:A10

Select A1:A10
1st RULE 
--> Using formula --> =A1="N"
Choose desired format. Example: Fill GREEN

2nd RULE 
--> Using formula --> =A1="NA"
Choose desired format. Example: Fill RED 

Please tell us if it worked for you.
I hope it helps.

Conditional Formatting

1 response

Similar discussions

Subscribe To Our Newsletter!