Put your name within quotes, like this:

=$B2="name"

Hope this helps.

Pete

On Nov 12, 4:40*pm, Shanie wrote:
I see examples for this where the cell is a numerical value, but I need to do
this where the cell is a person's name. *I have 2007 and I went to CF - new
rule- use formula to determine which cells to format. *My name is in column
B2 so I put =$B2=NAME and I get an error of "you may not use unions,
intersections, or array constants for CF critera". *What is the correct
formula I need to use for this?