Is there a non-macro method to conditionally formatting a cell based on the value of the cell above it? For example; A1's could be Tom, Dick, or Harry but I need A2 to be colored red if A1 is Tom, Blue if A1 is Dick, and Green if A1 is Harry.

If there's not a non-macro method, then I gotta give in and ask how this would be coded. Trying to avoid it but if not, cest la vie.

Thanks in advance for the help!