How to conditional format this:

[firstWeMeet]

Hi,
I just want to ask how could I set a conditional format a fill color format, the cell is C2 to V2 and set this as Black fill color if the W2 is equal to "HIGH" thanks, note that some of the cells from C2 to V2 has "IF" formula and the others is ordinary formula like =SUM()
Hope to receive from you guys. thanks

 

[VoG]

Select C2:V2, in Conditional Formatting use Formula Is with the formula#

=$W2="HIGH"

 

[RichardMGreen]

The fact that the cells in C2:V2 have formulas doesn't affect anything as you're looking at W2.
The conditional formatting would need to be a formula itself and would be something along the lines of:-
=if(W2="High",1,0)

and then set your formatting.

::edit::

Yours looks a lot simpler Peter.

 

[firstWeMeet]

I try Richard formula but just the C2 formatted, then the others nothing was change.

 

[VoG]

Try mine

 

[firstWeMeet]

Thanks for MR Vog. Its working :D

 

[firstWeMeet]

Opppsss.....
There was a trouble
I can't make the cell to drag it down its because the bellow cells got some data information already and its annoying to format C2 to C65

 

[VoG]

Select C2:V65 then apply the CF.

 

[firstWeMeet]

My Bad, I select C2 to W2 not C2 to V2
Now I want C2 to W2 make black color (for correction) if W2 is HIGH.
Thanks

 

[VoG]

Just select all the cells that you want to format and apply the CF formula.