Color cell range based on text in another cell?

[Eric Livesay]

Hello,

I'm pretty sure this is a simple answer but I can't figure it out.

I would like to color cells A7:F7 a certain color if cell G7 has an "X" in it.

I assume it's using Conditional Fomatting with the Use Formulas rule.


Thanks in advance!

 

[T. Valko]

Hello,

I'm pretty sure this is a simple answer but I can't figure it out.

I would like to color cells A7:F7 a certain color if cell G7 has an "X" in it.

I assume it's using Conditional Fomatting with the Use Formulas rule.


Thanks in advance!

Yes, that's what you want to do.

Select the *entire* range A7:F7 starting from cell A7. Cell A7 will be the
active cell. The active cell is the one cell in the selected range that is not shaded. The formula will be relative to the active cell.

• Goto the Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a formula to determine which cells to format
• Enter this formula in the box below:
• =$G$7="x"
• Click the Format button
• Select the desired style(s)
• OK out

 

[MDCurry]

Yes Conditional formatting is the way to go for this.

Highlight cells A7:F7
Under Conditional Formatting select New Rule.
Select "Use a formula to determine cells to format"
In the Rule Description box enter the formula...

if($G$7="x",true,false)

Click the Format button to select the color to fill..click OK

 

[Eric Livesay]

Thanks guys!

Both of your solutions work.

 

[T. Valko]

Thanks guys!

Both of your solutions work.

You're welcome. Thanks for the feedback!