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!
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.
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!