Yes there is, Select A1 - D1 and then

Format|conditional formatting|select formula is from the dropdown
Paste this in and select a colour
=$A$1<=0
Click ADD and repeat using the formula
=$A$10

Mike

"Positive" wrote:

Is there any way that we can create a formula when , eg, A1 is certain
value (-), then the whole range A1: D1 is filled with yellow color ;
A1 is certain value (+), then the whole range A1:D1 is filled with
green color?

Thanks
Lan