Conditional formating with an OR statement

[Brian Feth]

Windows 10, Excel 2010: How do I conditionally format the range A1:A100 to format for the cell value of "UNK", or "Unk" or "unk" using the OR statement?

=OR("UNK","Unk","unk") does not work.

 

[MARZIOTULLIO]

=COUNTIF($A1,"unk")>0

Applies to =$A$1:$A$100

 

[Special-K99]

Select A1:A100

In Condtional Formatting use this formula

=OR(A1="UNK",A1="Unk",A1="unk")
or
=(UPPER(A1)="UNK")

 

[MARZIOTULLIO]

with or

=OR($A1="UNK",$A1="Unk",$A1="unk")

Applies to =$A$1:$A$100

 

[Jonmo1]

Why not just =$A1="unk"

It is NOT case sensitive, so it would be true for Unk and UNK as well as unk.

 

[Jonmo1]

Or instead of using a formula in CF, use
format only cells that contain
Cell Value
Equal to
unk

 

[Brian Feth]

Thank you all. I used Jomno1's solution.

 

[Jonmo1]

You're welcome.