Conditional Formatting question

[Riptake]

Hi everyone,

Hope everyone is well. I have a quick question about conditional formatting. So I have a drop down list in cells A1:A4. The list contains the choices B, C and D. If choice B is made, I want the cell in the next column (and same row) "B2" to me conditionally formatted with a red border. If choice C is made, I want the cell in column C (and same row) "C2" to me conditionally formatted with a red border and finally id D is made, I want cell "D2" to be bordered with red. What is the best way to do this??

Thanks in advance!!

 

[BenMiller]

You have to conditionally format each of the three cells separately. In B2, go to conditional formatting, select Formula is, and type =A2="B" then set whatever format you want. Etc.

 

[cyrilbrd]

HI BenMiller
don't you mean:

=$A$1="b"

?

 

[BenMiller]

HI BenMiller
don't you mean:

=$A$1="b"

?

Why would would you want to lock it? If you do it my way you could format each row based on its column A ...

 

[cyrilbrd]

true, remove $ before 1.

 

[BenMiller]

true, remove $ before 1.

And copy/paste special>formatting across. I hear. Good stuff!