Conditional formatting

[Get_Involved]

I am trying to conditional format a row to accomplish this.

I need cell A1 when it contains the text “Sell” to fill color, Cells (A6:A10) to turn lets say Green.

Every thing I have tried so far has failed, this is just one of several formulas I have used

IF(C6="Sell",IF(B6:B10))

Thanks in Advance

 

[Fluff]

Select A6:A10 & use this formula
=$A$1="Sell"

 

[Get_Involved]

Thanks Fluff
That works fine I have changed the formula to fit my actual cells.

 =$C$6="Sell"

Ok now here is my question, can we make the formula to take care of any of the rows to include down to roe $C$35?

 

[Fluff]

In what way?

 

[Get_Involved]

I have 35 rows not all will have the text “Sell” in them, some will have the text “buy” in them I am not worried the “Buy.
I thought the formula could work all rows. Sorry

 

[Fluff]

So you want to highlight any cell that has Sell?
Is that right?

 

[Get_Involved]

No
In column C will have the text “Sell”, Columns (D:P) will have numbers in them, I just want to highlight those column rows only

 

[Fluff]

In that case select the cells in range D6:P last row that you want to highlight & use this formula
=$C6="Sell"

 

[Get_Involved]

Thanks Fluff

Works great

I almost had it, just didn't take out the second $ symbol.
Case closed thank you.

 

[Fluff]

You're welcome & thanks for the feedback