"If" Formula Question

[scottiedawg4]

For an "if" function, can I have the outcomes change formatting in an adjacent cell? For example, if I have text in A1:D1, and 1's OR 2's in A2:D2, can I have the formatting in column 1 change based off of what's in column 2? Thanks!

 

[Scott Huish]

Yes, in Conditional Formatting.

Select Column 1. (I'm assuming this to be column A in this example)

Conditional Formatting formula:

=$B1=1

and

second Conditional Formatting Formula:

=$B1=2

Format as desired.

 

[scottiedawg4]

Would that just look for "=$B1=1" in Column A? I imagine I'm just missing something obvious.

FYI, I put in that formula: Specific Text, Containing, =$B1=1, for the range =$A:$A, and formatted how I wanted. Nothing changed.

Thoughts?

 

[scottiedawg4]

I figured it out. Thank you HOTPEPPER!