How to highlight subsequent cell when "X" is entered in the cell before it

[DWads]

Hello excel experts!

I am using excel 2007 and I'm trying to figure out how to highlight a subsequent cell when the one before it has an "x" entered into it...and I am completely stuck! For example: when an "x" is entered into A1 then B2 (and only B2) is highlighted.

Although I'm fairly savvy with excel, I get lost when it comes to more complex programming so if you could provide step-by-step instructions that would be wonderful.

 

[CWatts]

It's actually quite easy.

Highlight B1 Create a new conditional format rule with the following formula:

=$A1="X"

And then set it as "applies to" =$B:$B

And done.

 

[DWads]

Ok sounds good and I know where the conditional formatting button is so we're off to a good start...but what exactly gets placed where in the pop-up new rule formatting box? Or am I supposed to select highlight cell rules and new rule?