Excel formula/Conditional formating

[tnoe]

How do I word this in to a formula?

If H7 is less than zero then I need the cell G7 to automaticlly be highlighted.

Can this be none in conditional formating?

Thanks
Tnoe

 

[Zack Barresse]

in G7, CF -> Formula is... -> =H7<0

highlight as desired per format.

HTH

 

[tnoe]

THANK YOU.

Now I run into another question.

How do you word this in Conditional formating?

If A11 is greater than zero then B11 through f11 highlights.

Thanks
Tnoe

 

[Aladin Akyurek]

...How do you word this in Conditional formating?

If A11 is greater than zero then B11 through f11 highlights...

Are you looking for:

=MATCH($B11,$B$11:$F$11,0)*(N($A$11)>0)