Conditional formatting by using formula

[Hrishi]

Hello, I have few figures arranged in row. In columns 1 i have a figure for reference and I want to highlight figures from columns number 2 to 9 in such a way that summation of those highlighted figures from columns 2 to column under consideration shall be less than figure in column number 1 i.e. 30.

I tried to use sum($2:3)<$1, but ist not working, and if i drag it on right column number 3 in formula is not dragging along.

[TABLE="class: grid, width: 500, align: left"]
<colgroup><col width="98"><col width="85" span="8"><col width="85"><col width="85"></colgroup><tbody>[TR]
[TD="width: 85"]1
[/TD]
[TD="width: 85"]2
[/TD]
[TD="width: 85"]3
[/TD]
[TD="width: 85"]4
[/TD]
[TD="width: 85"]5
[/TD]
[TD="width: 85"]6
[/TD]
[TD="width: 85"]7
[/TD]
[TD="width: 85"]8
[/TD]
[TD="width: 85"]9
[/TD]
[/TR]
[TR]
[TD="width: 85"] - 30
[/TD]
[TD="width: 85"] 5
[/TD]
[TD="width: 85"]10
[/TD]
[TD="width: 85"]5
[/TD]
[TD="width: 85"]3
[/TD]
[TD="width: 85"]3
[/TD]
[TD="width: 85"]5
[/TD]
[TD="width: 85"]5
[/TD]
[TD="width: 85"]3
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Oh I see, I had typed Sum($G4:G4)<$F4 and entered then excel put sign of = and " quotes on its own. so i thought its default correction by excel. so i didn't try to remove it.
Thanks a lot sir. Now it worked as I wanted. A big Thank to you.

You are very welcome. Yes, you need to enter the entire formula, including the = sign at the start.