Previous Topic Next Topic

Conditional Formatting

Closed
Rahul - Apr 29, 2016 at 04:09 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Apr 29, 2016 at 09:24 AM
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 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Apr 29, 2016 at 09:24 AM
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.
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses