Need a way to conditionally format a cell based on an adjacent cells value.

[Orestees]

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!

[mrmmickle1]

Orestees,

Look at Sheet 1 in the attachment.

Go to conditional formatting on the Home Tab. Then Click.

Go to Manage Rules then Click.

You should understand what to do from there.

[Orestees]

Awesome, I just really needed to take a look at it, thanks. I first tried changing the 'applies to' formula to =$A$2, but it changed all of the rules to match A2's. So I went back in to the rules and changed them back to A1's and left the 'applies to' formula as =$A$2 and it kept it. Now A2 highlights based on A1's value. Thanks for the very helpful nudge!! Again, you are a live saver!