Conditional Formatting

[Grumpy9215]

I want to set up formula in conditional formating so that when:
$AF6 = "CA" the color is red
or
if $AF6 = ("GA","ME","PR") then the color is blue

what I came up with is
Condition 1
= ($AF6 ="ca") [which will turn the cell red]
Condition 2
="OR($AF6={""GA"",""ME"",""PR""}, "")" [which doesn't do anything]

Thanks

[rwgrietveld]

and this

=OR($AF6="GA",$AF6="ME",$AF6="PR")

This also works =OR($AF6={"GA","ME","PR"}), but not for CF as you can't have an array in CF formula's

What does work is to make a name and use that =OR($AF6=Values)

Values refers to ={"GA";"ME";"PR"}

[Grumpy9215]

Works great! Thanks!