Apply conditional formatting to all rows in worksheet

[toant]

I have values in column A that I would like to make a conditional formatting for. If the value in Column A is less than the Sum of column D, E, F in the same row then cell A3 will be red and green if it is greater. I want to apply this to all rows down the list.

This is just a sample for simplicity but the actual data is actually more.

I just want to find a quick way to apply to all the data instead of having to apply the condition one at a time to each row.

Thanks.

 

[toant]

I have values in column A that I would like to make a conditional formatting for. If the value in Column A is less than the Sum of column D, E, F in the same row then cell A3 will be red and green if it is greater. I want to apply this to all rows down the list.

This is just a sample for simplicity but the actual data is actually more.

I just want to find a quick way to apply to all the data instead of having to apply the condition one at a time to each row.

Thanks.

Sample Data uploaded

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F
2	Amount needed
3	3			3	1	5
4	7			0	5	4
5	6			6	0	0
6	9			0	2	1
7
8
9
10
Result

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:A10	Expression	=A3>SUM($D3:$F3)	text	NO
A3:A10	Expression	=AND(A3<>"",A3<SUM($D3:$F3))	text	NO