Conditional Formatting [Closed]

Report
-
Posts
1927
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 17, 2021
-
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".


1 reply

Posts
1927
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 17, 2021
143
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!