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?